Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PG_RLSPOLICY

Updated on 2024-12-19 GMT+08:00

PG_RLSPOLICY displays the information about row-level access control policies.

Table 1 PG_RLSPOLICY columns

Name

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:

  • true: The row-level access control policy is a permissive policy.
  • false: The row-level access control policy is a restrictive policy.

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

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback