18th October 2018: PostgreSQL 11 Released!
Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4 / 9.3
Development Versions: devel
Unsupported versions: 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0

48.45. 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 48-45. pg_tablespace Columns

Name Type References Description
oid oid   Row identifier (hidden attribute; must be explicitly selected)
spcname name   Tablespace name
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

Submit correction

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.