select open change scope Open full search

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

SYSTEM CATALOGS / SYSTEM CATALOGS

The catalog pg_tablespace stores information about the available tablespaces.

Kind
System catalogs
Columns in this snapshot
5
Definition source
English manual

Columns 5

ColumnTypeDescription / reference
oidoidRow identifier
spcnamenameTablespace name
spcowneroidOwner of the tablespace, usually the user who created it
pg_authid.oid
spcaclaclitem[]Access privileges; see Section 5.8 for details
spcoptionstext[]Tablespace-level options, as “keyword=value” strings
Column history across versions
Version history 6
  1. PG 18 → 19changed
  2. PG 16 → 17changed
  3. PG 11 → 12changed
  4. PG 9.6 → 10changed
  5. PG 9.2 → 9.3changed
  6. PG 9.1 → 9.2changed

Definition snapshot: english-manuals:54d7bf8b8e898c9326ede47978a… · English manual source