W3cubDocs

/PostgreSQL 9.6

50.32. 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 50-32. 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.
https://www.postgresql.org/docs/9.6/static/catalog-pg-namespace.html