Wiki / psql Commands / Scripting and assistance
\unrestrict
Exit "restricted" mode (i.e., where all other meta-commands are blocked), provided the specified key matches the one given to \restrict when restricted mode was entered.
Reading PostgreSQL 18.6.
Description
Exit "restricted" mode (i.e., where all other meta-commands are blocked), provided the specified key matches the one given to \restrict when restricted mode was entered.
- Client
- psql 18.6
- Case-sensitive spelling
- \unrestrict
Usage
\unrestrict restrict_keySpellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \unrestrict | None listed in this signature |
Manual definition
\unrestrictrestrict_key-
Exit "restricted" mode (i.e., where all other meta-commands are blocked), provided the specified key matches the one given to
\restrictwhen restricted mode was entered.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.
Unlike most other meta-commands, the entire remainder of the line is always taken to be the argument of
\unrestrict, and neither variable interpolation nor backquote expansion are performed.
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 12 → 13: added.
--- PostgreSQL 12
+++ PostgreSQL 13
@@ -1 +1,8 @@
-Not recorded in this version
+{
+ "definition": "Exit \"restricted\" mode (i.e., where all other meta-commands are blocked), provided the specified key matches the one given to \\restrict when restricted mode was entered. 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.",
+ "modifiers": [],
+ "signature": "\\unrestrict restrict_key",
+ "spellings": [
+ "\\unrestrict"
+ ]
+}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.