12th September 2019: PostgreSQL 12 Beta 4 Released!
Supported Versions: Current (11) / 10 / 9.6 / 9.5 / 9.4
Development Versions: 12 / devel
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.

45.41. 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 45-41. 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
spcoptions text[]   Tablespace-level options, as "keyword=value" strings