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

column type references description
oid oid   Row identifier (hidden attribute; must be explicitly selected)
nspname name   Name of the namespace
nspowner oid pg_authid.oid Owner of the namespace
nspacl aclitem[]   Access privileges as given by GRANT and REVOKE

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon