PG_SHSECLABEL
PG_SHSECLABEL records security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command.
For an easier way to view security labels, see PG_SECLABELS.
See also PG_SECLABEL, which performs a similar function for security labels involving objects within a single database.
Unlike most system catalogs, PG_SHSECLABEL is shared across all databases of a cluster. There is only one copy of PG_SHSECLABEL per cluster, not one per database.
| 
        Name  | 
      
        Type  | 
      
        Reference  | 
      
        Description  | 
     
|---|---|---|---|
| 
        objoid  | 
      
        OID  | 
      
        Any OID column  | 
      
        OID of the object this security label pertains to  | 
     
| 
        classoid  | 
      
        OID  | 
      
        PG_CLASS.oid  | 
      
        OID of the system catalog where the object resides  | 
     
| 
        provider  | 
      
        Text  | 
      
        N/A  | 
      
        Label provider associated with this label  | 
     
| 
        label  | 
      
        Text  | 
      
        N/A  | 
      
        Security label applied to this object  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.