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.