↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / System Catalogs

pg_namespace

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

kind
catalog
lang
en
measured attributes
true
metadata release
18.6
runtime columns
oid, nspname, nspowner, nspacl
runtime verified
false
source
english-manual

Definition PG 18

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.

Catalog columns

ColumnTypeNullabilityDescription
oidoidNot nullRow identifier
nspnamenameNot nullName of the namespace
nspowneroidNot nullOwner of the namespace
nspaclaclitem[]NullableAccess privileges; see Section 5.8 for details

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:2d926abb639410861dcbc2b231e6310c7358ba8e3e6e10afccac8555636cebeb

Text language: en · catalog-bilingual-repair:2d926abb639410861dcbc2b231e6310c7358ba8e3e6e10afccac8555636cebeb