PG_NAMESPACE
PG_NAMESPACE records the namespaces, that is, schema-related information.
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 sections "GRANT" and "REVOKE" in Data Warehouse Service (DWS) SQL Syntax Reference. |
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. This parameter is supported only in 8.3.0 and later versions to adapt to LakeFormation features. NOTE: The nsptype field is added to distinguish 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.

