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

System Catalogs / System catalogs

pg_tablespace

Read the PG 18 manual

The catalog pg_tablespace stores information about the available tablespaces.

Reading PG 18current·documented in 23 of 24 versions, 8.0 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

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

Columns 5

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`oid`	`oid`NOT NULL	Row identifier
`spcname`	`name`NOT NULL	Tablespace name
`spcowner`	`oid`NOT NULL	Owner of the tablespace, usually the user who created it pg_authid.oid
`spcacl`	`aclitem[]`	Access privileges; see Section 5.8 for details
`spcoptions`	`text[]`	Tablespace-level options, as “keyword=value” strings

Column history across versions

oid

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

spcname

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

spcowner

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

spcacl

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

spcoptions

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

spclocation

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Version history 9

18 → 19 reworded
16 → 17 reworded
11 → 12 changed
9.6 → 10 reworded
9.1 → 9.2 changed
8.4 → 9.0 changed
8.1 → 8.2 reworded
8.0 → 8.1 changed
7.4 → 8.0 added

Definition snapshot: english-manuals:e74749f15616193d15ac4af181a… · English manual source