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 50-47. pg_tablespace Columns
|oid||oid||Row identifier (hidden attribute; must be explicitly selected)|
|spcowner||oid||pg_authid.oid||Owner of the tablespace, usually the user who created it|
|spcacl||aclitem||Access privileges; see GRANT and REVOKE for details|
|spcoptions||text||Tablespace-level options, as "keyword=value" strings|
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.