Updated on 2023-10-23 GMT+08:00

PG_RLSPOLICIES

PG_RLSPOLICIES contains row-level access control policies. The initial user and users with the sysadmin attribute can view all policy information. Other users can view only the policy information in their own tables.

Table 1 PG_RLSPOLICIES columns

Name

Type

Description

schemaname

name

Name of the schema of the table object to which a row-level access control policy is applied

tablename

name

Name of the table object to which the row-level access control policy is applied

policyname

name

Name of the row-level access control policy

policypermissive

text

Attribute of the row-level access control policy

policyroles

name[]

List of users affected by the row-level access control policy. If this parameter is not specified, all users are affected.

policycmd

text

SQL operations affected by the row-level access control policy

policyqual

text

Expression of the row-level access control policy