Wiki / psql Commands / Scripting and assistance
\restrict
Enter "restricted" mode with the provided key. In this mode, the only allowed meta-command is \unrestrict , to exit restricted mode. The key may contain only alphanumeric characters.
Reading PostgreSQL 18.6.
Description
Enter "restricted" mode with the provided key. In this mode, the only allowed meta-command is \unrestrict , to exit restricted mode. The key may contain only alphanumeric characters.
- Client
- psql 18.6
- Case-sensitive spelling
- \restrict
Usage
\restrict restrict_keySpellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \restrict | None listed in this signature |
Manual definition
\restrictrestrict_key-
Enter "restricted" mode with the provided key. In this mode, the only allowed meta-command is
\unrestrict, to exit restricted mode. The key may contain only alphanumeric characters.This command is primarily intended for use in plain-text dumps generated by pg_dump, pg_dumpall, and pg_restore, but it may be useful elsewhere.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: unchanged.
Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 13 through 20; the first sample is not necessarily its introduction.