SYSTEM CATALOGS / SYSTEM CATALOGS
pg_tablespace
Read PG 18 manual ↗The catalog pg_tablespace stores information about the available tablespaces.
- Kind
- System catalogs
- Columns in this snapshot
- 5
- Definition source
- English manual
Columns 5
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
spcname | name | Tablespace name |
spcowner | oid | 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
Version history 6
- PG 18 → 19changed
- PG 16 → 17changed
- PG 11 → 12changed
- PG 9.6 → 10changed
- PG 9.2 → 9.3changed
- PG 9.1 → 9.2changed
Definition snapshot: english-manuals:54d7bf8b8e898c9326ede47978a… · English manual source