September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 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 other supported versions listed above instead.

49.46. 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 49-46. 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