The pg_tablespace catalog provides information about the available tablespaces.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
The OID of the tablespace. |
spcname |
name |
The name of the tablespace. |
spcowner |
oid (references pg_authid.oid) |
The OID of the role that owns the tablespace (usually the user who created it). |
spcacl |
aclitem[] |
An array of ACL entries that define the access privileges for the tablespace. |
spcoptions |
text[] |
An array of tablespace-level options, each in the “keyword=value” format. |