pg_tablespace
The catalog pg_tablespace
stores information
about the available tablespaces. Tables can be placed in particular
tablespaces to aid administration of disk layout.
Unlike most system catalogs, pg_tablespace
is shared across all databases of a cluster: there is only one
copy of pg_tablespace
per cluster, not
one per database.
Table 51.55. pg_tablespace
Columns
Name | Type | References | Description |
---|---|---|---|
oid | oid | Row identifier | |
spcname | name | Tablespace name | |
spcowner | oid |
| Owner of the tablespace, usually the user who created it |
spcacl | aclitem[] | Access privileges; see Section 5.7 for details | |
spcoptions | text[] | Tablespace-level options, as “keyword=value” strings |