{"Entry":{"collection":"psql","key":"cmd-73-65-74","name":"\\set","aliases":["\\set"],"metadata":{"aliases":["\\set"],"category":"Scripting and assistance","content_hash":"a2b95629537b9869ac24e0eeb36218de0d104e9afe564ba103fa7eb52f551a96","derived_content_hash":"c5f74a1adf4a09fb4096aaa44ef1639fb0272373fa39fd45f8df691086437d72","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.183162+08:00","name":"\\set","name_zh":"","slug":"cmd-73-65-74","summary":"Sets the psql variable name to value , or if more than one value is given, to the concatenation of all of them. If only one argument is given, the variable is set to an empty-string value. To unset a variable, use the \\unset command."}},"Definition":{"Collection":"psql","Key":"cmd-73-65-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-73-65-74","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\set","comparison_data":{"definition":"Sets the psql variable name to value , or if more than one value is given, to the concatenation of all of them. If only one argument is given, the variable is set to an empty-string value. To unset a variable, use the \\unset command. \\set without any arguments displays the names and values of all currently-set psql variables. Valid variable names can contain letters, digits, and underscores. See Variables below for details. Variable names are case-sensitive. Certain variables are special, in that they control psql 's behavior or are automatically set to reflect connection state. These variables are documented in Variables , below. Note This command is unrelated to the SQL command SET .","modifiers":[],"signature":"\\set [ name [ value [ ... ] ] ]","spellings":["\\set"]},"comparison_hash":"4ccab889961521d65dc52159ba29d4e119498b265c284df8c2f916c616b0da0e","description":["Sets the psql variable name to value , or if more than one value is given, to the concatenation of all of them. If only one argument is given, the variable is set to an empty-string value. To unset a variable, use the \\unset command."],"description_zh":"设置 psql 变量 name 为 value ，如果给出多个值，则设置为所有值的连接。如果只给出一个参数，则将变量设置为空字符串值。要取消变量设置，请使用 \\unset 命令。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        设置 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e 变量 \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e 为 \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e，如果给出多个值，则设置为所有值的连接。如果只给出一个参数，则将变量设置为空字符串值。要取消变量设置，请使用\u003ccode class=\"command\"\u003e\\unset\u003c/code\u003e 命令。\n        \u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003e\\set\u003c/code\u003e 没有任何参数时，显示当前设置的所有 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e 变量的名称和值。\u003c/p\u003e\u003cp\u003e\n        有效的变量名可以包含字母、数字和下划线。有关详细信息，请参见下面的\u003ca class=\"xref\" href=\"/zh/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"变量\"\u003e变量\u003c/a\u003e。变量名区分大小写。\n        \u003c/p\u003e\u003cp\u003e\n        某些变量是特殊的，它们控制 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e 的行为或者自动设置以反映连接状态。这些变量在下面的\u003ca class=\"xref\" href=\"/zh/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"变量\"\u003e变量\u003c/a\u003e中有文档记录。\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003e注意\u003c/h3\u003e\u003cp\u003e\n        这个命令与 \u003cacronym class=\"acronym\"\u003eSQL\u003c/acronym\u003e 命令 \u003ca class=\"link\" href=\"/zh/docs/18/sql-set.html\" title=\"SET\"\u003e\u003ccode class=\"command\"\u003eSET\u003c/code\u003e\u003c/a\u003e 无关。\n        \u003c/p\u003e\u003c/div\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":"\\set"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\set"}],"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-SET\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\set [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e [ ... ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Sets the \u003cspan class=\"application\"\u003epsql\u003c/span\u003e variable \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e, or if more than one value\n        is given, to the concatenation of all of them. If only one\n        argument is given, the variable is set to an empty-string value. To\n        unset a variable, use the \u003ccode class=\"command\"\u003e\\unset\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003e\\set\u003c/code\u003e without any arguments displays the names and values\n        of all currently-set \u003cspan class=\"application\"\u003epsql\u003c/span\u003e variables.\n        \u003c/p\u003e\u003cp\u003e\n        Valid variable names can contain letters, digits, and\n        underscores. See \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\"\u003eVariables\u003c/a\u003e below for details.\n        Variable names are case-sensitive.\n        \u003c/p\u003e\u003cp\u003e\n        Certain variables are special, in that they\n        control \u003cspan class=\"application\"\u003epsql\u003c/span\u003e's behavior or are\n        automatically set to reflect connection state.  These variables are\n        documented in \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\"\u003eVariables\u003c/a\u003e, below.\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\u003cp\u003e\n        This command is unrelated to the SQL\n        command \u003ca class=\"link\" href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003ccode class=\"command\"\u003eSET\u003c/code\u003e\u003c/a\u003e.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-SET","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":"\\set [ name [ value [ ... ] ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-SET","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-SET"}],"spellings":["\\set"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\set","url":"/wiki/psql/cmd-73-65-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":"\\set","url":"/wiki/psql/cmd-73-65-74/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-SET","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-SET","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-SET"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-73-65-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\set","Summary":"Sets the psql variable name to value , or if more than one value is given, to the concatenation of all of them. If only one argument is given, the variable is set to an empty-string value. To unset a variable, use the \\unset command.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-SET\"\u003e\u003cspan\u003e\u003ccode\u003e\\set [ \u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e [ ... ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Sets the \u003cspan\u003epsql\u003c/span\u003e variable \u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e to \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e, or if more than one value\n        is given, to the concatenation of all of them. If only one\n        argument is given, the variable is set to an empty-string value. To\n        unset a variable, use the \u003ccode\u003e\\unset\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\u003ccode\u003e\\set\u003c/code\u003e without any arguments displays the names and values\n        of all currently-set \u003cspan\u003epsql\u003c/span\u003e variables.\n        \u003c/p\u003e\u003cp\u003e\n        Valid variable names can contain letters, digits, and\n        underscores. See \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\" rel=\"nofollow\"\u003eVariables\u003c/a\u003e below for details.\n        Variable names are case-sensitive.\n        \u003c/p\u003e\u003cp\u003e\n        Certain variables are special, in that they\n        control \u003cspan\u003epsql\u003c/span\u003e\u0026#39;s behavior or are\n        automatically set to reflect connection state.  These variables are\n        documented in \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\" rel=\"nofollow\"\u003eVariables\u003c/a\u003e, below.\n        \u003c/p\u003e\u003cdiv\u003e\u003ch3\u003eNote\u003c/h3\u003e\u003cp\u003e\n        This command is unrelated to the SQL\n        command \u003ca href=\"/docs/18/sql-set.html\" title=\"SET\" rel=\"nofollow\"\u003e\u003ccode\u003eSET\u003c/code\u003e\u003c/a\u003e.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"88997ef315fe382e9b97ba82f58dc178a960921587fa6ab01e6c9dbe007eb991","Payload":{"description":["Sets the psql variable name to value , or if more than one value is given, to the concatenation of all of them. If only one argument is given, the variable is set to an empty-string value. To unset a variable, use the \\unset command."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-SET\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\set [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e [ ... ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Sets the \u003cspan class=\"application\"\u003epsql\u003c/span\u003e variable \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e, or if more than one value\n        is given, to the concatenation of all of them. If only one\n        argument is given, the variable is set to an empty-string value. To\n        unset a variable, use the \u003ccode class=\"command\"\u003e\\unset\u003c/code\u003e command.\n        \u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003e\\set\u003c/code\u003e without any arguments displays the names and values\n        of all currently-set \u003cspan class=\"application\"\u003epsql\u003c/span\u003e variables.\n        \u003c/p\u003e\u003cp\u003e\n        Valid variable names can contain letters, digits, and\n        underscores. See \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\"\u003eVariables\u003c/a\u003e below for details.\n        Variable names are case-sensitive.\n        \u003c/p\u003e\u003cp\u003e\n        Certain variables are special, in that they\n        control \u003cspan class=\"application\"\u003epsql\u003c/span\u003e's behavior or are\n        automatically set to reflect connection state.  These variables are\n        documented in \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES\" title=\"Variables\"\u003eVariables\u003c/a\u003e, below.\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\u003cp\u003e\n        This command is unrelated to the SQL\n        command \u003ca class=\"link\" href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003ccode class=\"command\"\u003eSET\u003c/code\u003e\u003c/a\u003e.\n        \u003c/p\u003e\u003c/div\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":"\\set","url":"/wiki/psql/cmd-73-65-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\set","Signature":"\\set [ name [ value [ ... ] ] ]","Modifiers":[]}],"SQLState":null,"Evidence":null}