PG_RLSPOLICY
PG_RLSPOLICY displays the information about row-level access control policies.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        polname  | 
      
        Name  | 
      
        Name of a row-level access control policy  | 
     
| 
        polrelid  | 
      
        OID  | 
      
        Table OID of a row-level access control policy  | 
     
| 
        polcmd  | 
      
        Char  | 
      
        SQL operations affected by a row-level access control policy. The options are *(ALL), r(SELECT), w(UPDATE), and d(DELETE).  | 
     
| 
        polpermissive  | 
      
        Boolean  | 
      
        Type of a row-level access control policy 
         NOTE: 
         Values of polpermissive: 
  | 
     
| 
        polroles  | 
      
        oid[]  | 
      
        OID of database user affected by a row-level access control policy  | 
     
| 
        polqual  | 
      
        pg_node_tree  | 
      
        SQL condition expression of a row-level access control policy  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.