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.

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
doc_PostgreSQL
2016-10-12 11:32:33
Comments
Leave a Comment

Please login to continue.