↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 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
Historical version. PostgreSQL 8.3 reached end of support in February 2013. See the current version for supported releases.
PostgreSQL 8.3.23 Documentation
Prev Fast Backward Chapter 44. System Catalogs Fast Forward Next

44.34. 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 44-34. 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
Prev Home Next
pg_statistic Up pg_trigger

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.