pg_tablespace
The pg_tablespace system catalog table stores information about the available tablespaces.
Unlike most system catalogs, pg_tablespace is shared across all databases of a Greengage DB system: there is only one copy of pg_tablespace per system, not one per database.
| Column | Type | References | Description |
|---|---|---|---|
spcname |
name |
— |
Tablespace name |
spcowner |
oid |
pg_authid.oid |
Owner of the tablespace, usually the user that created it |
spcacl |
aclitem[] |
— |
Tablespace access privileges |
spcoptions |
text[] |
— |
Tablespace locations by content ID |