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 43-32. pg_tablespace Columns
| Name | Type | References | Description |
|---|
| spcname | name | | Tablespace name |
| spcowner | oid | pg_authid.oid | Owner of the tablespace, usually the user who created it |
| spclocation | text | | Location (directory path) of the tablespace |
| spcacl | aclitem[] | | Access privileges; see
GRANT and
REVOKE
for details
|