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