Wiki / Configuration Parameters

This variable controls whether to raise an error in lieu of applying a row security policy. When set to on, policies apply normally. When set to off, queries fail which would otherwise apply at least one policy. The default is on. Change to off where limited row visibility could cause incorrect results; for example, pg_dump makes that change by default. This variable has no effect on roles which bypass every row security policy, to wit, superusers and roles with the BYPASSRLS attribute. For more information on row security policies, see CREATE POLICY.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

on

category

Client Connection Defaults / Statement Behavior

context

user

documented

true

enumvals

Unknown

extra desc

When enabled, row security will be applied to all users.

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

row_security

short desc

Enables row security.

source

pg-settings-source-snapshot

unit

Unknown

vartype

bool