{"Entry":{"collection":"psql","key":"cmd-75-6e-72-65-73-74-72-69-63-74","name":"\\unrestrict","aliases":["\\unrestrict"],"metadata":{"aliases":["\\unrestrict"],"category":"Scripting and assistance","content_hash":"19c9306ef609fd1186b5c7184fae459f0f8d1775ed8af60c64287727eed0fdd5","derived_content_hash":"1abfa4e3bbfc29b8ded77dcaebb5494dd25445cc9f2341486019ef89a698ea9f","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:45.214425+08:00","name":"\\unrestrict","name_zh":"","slug":"cmd-75-6e-72-65-73-74-72-69-63-74","summary":"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."}},"Definition":{"Collection":"psql","Key":"cmd-75-6e-72-65-73-74-72-69-63-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-75-6e-72-65-73-74-72-69-63-74","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\unrestrict","comparison_data":{"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. 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.","modifiers":[],"signature":"\\unrestrict restrict_key","spellings":["\\unrestrict"]},"comparison_hash":"42c89ebee24ddfed72895699a5b74e1ca166907331cbad9e0ce4447b16f6631c","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."],"description_zh":"退出 “ 受限 ” 模式（即所有其他元命令都被阻止的模式），前提是指定的密钥与进入受限模式时传给 \\restrict 的密钥匹配。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        退出\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e受限\u003c/span\u003e”\u003c/span\u003e模式（即所有其他元命令都被阻止的模式），前提是指定的密钥与进入受限模式时传给\u003ccode class=\"command\"\u003e\\restrict\u003c/code\u003e 的密钥匹配。\n        \u003c/p\u003e\u003cp\u003e\n        此命令主要用于 \u003cspan class=\"application\"\u003epg_dump\u003c/span\u003e、\u003cspan class=\"application\"\u003epg_dumpall\u003c/span\u003e\n        和 \u003cspan class=\"application\"\u003epg_restore\u003c/span\u003e 生成的纯文本转储文件中，但在其他场景下也可能有用。\n        \u003c/p\u003e\u003cp\u003e\n        与大多数其他元命令不同，整个剩余行始终被视为\u003ccode class=\"command\"\u003e\\unrestrict\u003c/code\u003e 的参数，并且不会执行变量插值或反引号扩展。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\unrestrict"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\unrestrict"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-UNRESTRICT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\unrestrict \u003cem class=\"replaceable\"\u003e\u003ccode\u003erestrict_key\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Exit \"restricted\" mode (i.e., where all other meta-commands are\n        blocked), provided the specified key matches the one given to\n        \u003ccode class=\"command\"\u003e\\restrict\u003c/code\u003e when restricted mode was entered.\n        \u003c/p\u003e\u003cp\u003e\n        This command is primarily intended for use in plain-text dumps\n        generated by \u003cspan class=\"application\"\u003epg_dump\u003c/span\u003e,\n        \u003cspan class=\"application\"\u003epg_dumpall\u003c/span\u003e, and\n        \u003cspan class=\"application\"\u003epg_restore\u003c/span\u003e, but it may be useful elsewhere.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument of \u003ccode class=\"command\"\u003e\\unrestrict\u003c/code\u003e, and\n        neither variable interpolation nor backquote expansion are performed.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-UNRESTRICT","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\unrestrict restrict_key","sources":[{"anchor":"APP-PSQL-META-COMMAND-UNRESTRICT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-UNRESTRICT"}],"spellings":["\\unrestrict"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\unrestrict","url":"/wiki/psql/cmd-75-6e-72-65-73-74-72-69-63-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\unrestrict","url":"/wiki/psql/cmd-75-6e-72-65-73-74-72-69-63-74/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-UNRESTRICT","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-UNRESTRICT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-UNRESTRICT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-75-6e-72-65-73-74-72-69-63-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\unrestrict","Summary":"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.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-UNRESTRICT\"\u003e\u003cspan\u003e\u003ccode\u003e\\unrestrict \u003cem\u003e\u003ccode\u003erestrict_key\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Exit \u0026#34;restricted\u0026#34; mode (i.e., where all other meta-commands are\n        blocked), provided the specified key matches the one given to\n        \u003ccode\u003e\\restrict\u003c/code\u003e when restricted mode was entered.\n        \u003c/p\u003e\u003cp\u003e\n        This command is primarily intended for use in plain-text dumps\n        generated by \u003cspan\u003epg_dump\u003c/span\u003e,\n        \u003cspan\u003epg_dumpall\u003c/span\u003e, and\n        \u003cspan\u003epg_restore\u003c/span\u003e, but it may be useful elsewhere.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument of \u003ccode\u003e\\unrestrict\u003c/code\u003e, and\n        neither variable interpolation nor backquote expansion are performed.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"9d2c6058febf168bfef8cb8350906ea1140e26caed5889322b62d5575d1cea3a","Payload":{"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."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-UNRESTRICT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\unrestrict \u003cem class=\"replaceable\"\u003e\u003ccode\u003erestrict_key\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Exit \"restricted\" mode (i.e., where all other meta-commands are\n        blocked), provided the specified key matches the one given to\n        \u003ccode class=\"command\"\u003e\\restrict\u003c/code\u003e when restricted mode was entered.\n        \u003c/p\u003e\u003cp\u003e\n        This command is primarily intended for use in plain-text dumps\n        generated by \u003cspan class=\"application\"\u003epg_dump\u003c/span\u003e,\n        \u003cspan class=\"application\"\u003epg_dumpall\u003c/span\u003e, and\n        \u003cspan class=\"application\"\u003epg_restore\u003c/span\u003e, but it may be useful elsewhere.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument of \u003ccode class=\"command\"\u003e\\unrestrict\u003c/code\u003e, and\n        neither variable interpolation nor backquote expansion are performed.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\unrestrict","url":"/wiki/psql/cmd-75-6e-72-65-73-74-72-69-63-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\unrestrict","Signature":"\\unrestrict restrict_key","Modifiers":[]}],"SQLState":null,"Evidence":null}