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

System Catalogs / System catalogs

pg_namespace

Read the PG 18 manual

The catalog pg_namespace stores namespaces.

Reading PG 18current·documented in 24 of 24 versions, 7.4 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: 4
Definition source: English manual
Metadata snapshot: 18.6

Columns 4

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`oid`	`oid`NOT NULL	Row identifier
`nspname`	`name`NOT NULL	Name of the namespace
`nspowner`	`oid`NOT NULL	Owner of the namespace pg_authid.oid
`nspacl`	`aclitem[]`	Access privileges; see Section 5.8 for details

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

nspname

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

nspowner

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

nspacl

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 6

18 → 19 reworded
16 → 17 reworded
11 → 12 changed
8.1 → 8.2 reworded
8.0 → 8.1 changed
7.4 → 8.0 reworded

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