pg_namespace
pg_namespace#
The pg_namespace system catalog table 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 1. pg_catalog.pg_namespace
column |
type |
references |
description |
|---|---|---|---|
|
oid |
Row identifier (hidden attribute; must be explicitly selected) |
|
|
name |
Name of the namespace |
|
|
oid |
pg_authid.oid |
Owner of the namespace |
|
aclitem[] |
Access privileges as given by GRANT and REVOKE |
|
|
oid |
pg_tablespace.oid |
defualt tablespace of the namespace |