This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1

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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group