Set relation kinds for which access to non-system relations is prohibited.
At a glance
| Property | Value |
|---|---|
| Parameter | restrict_nonsystem_relation_kind |
| Category | Client Connection Defaults |
| Default | (see documentation) |
| Value type | string |
| Change scope | Per-session (SET) |
| Available in | PostgreSQL 12, 13, 14, 15, 16, 17, 18, 19 (added in 12) |
What it does
Set relation kinds for which access to non-system relations is prohibited. The value takes the form of a comma-separated list of relation kinds. Currently, the supported relation kinds are view and foreign-table.
(Description quoted from the official PostgreSQL documentation.)
How to apply a change
Can be set per session with SET, per role/database with ALTER ROLE/DATABASE ... SET, or globally in postgresql.conf.
Inspect the current value and source with SHOW restrict_nonsystem_relation_kind; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';.
Tuning guidance
This sets a session default (locale, formatting, search path or transaction behaviour) rather than a performance knob. Set it per role or database with ALTER ROLE/DATABASE ... SET so the right default follows the right workload, and prefer setting it explicitly in the application for behaviour the query results depend on.
Reference
PostgreSQL documentation — restrict_nonsystem_relation_kind.