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.

Table 49-31. pg_namespace Columns

Name 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; see GRANT and REVOKE for details