PG_NAMESPACE
PG_NAMESPACE records the namespaces, that is, schema-related information. The nsptype column is added to the cloud native data warehouse 3.0 to distinguish external schemas from common schemas. The value of external schema is e, and the value of common schema is i.
Column |
Type |
Description |
---|---|---|
nspname |
name |
Name of the namespace |
nspowner |
oid |
Owner of the namespace |
nsptimeline |
bigint |
Timeline when the namespace is created on the DN This column is for internal use and valid only on the DN. |
nspacl |
aclitem[] |
Access permissions. For details, see GRANT and REVOKE. |
permspace |
bigint |
Quota of a schema's permanent tablespace |
usedspace |
bigint |
Used size of a schema's permanent tablespace |
nsptype |
char |
Distinguishes external schemas from common schemas. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.