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.