/PostgreSQL 9.5

49.31. 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.

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

© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.