| Tablespace name | Tablespace owner | Location | ACL | Size |
| pg_default | guillaume | 382 MB | ||
| pg_global | guillaume | 327 kB | ||
| toto | guillaume | /opt/tblspc | 4100 bytes | |
| ts1 | guillaume | /opt/tblspc2 | 4100 bytes |
SELECT spcname, rolname AS owner, spclocation, spcacl, pg_size_pretty(pg_tablespace_size(spcname)) AS size FROM pg_tablespace, pg_roles WHERE spcowner = pg_roles.oid ORDER BY rolname