{"Entry":{"collection":"sql","key":"reset","name":"RESET","aliases":["reset"],"metadata":{"aliases":["reset"],"changed_in":["7.2","7.4","8.2"],"changes":[{"from":"6.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","usage"],"removed":[]},"status":"changed","synopsis":null,"to":"6.5"},{"from":"6.5","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"7.0"},{"from":"7.0","purpose_changed":true,"renamed":{"from_file":"sql-reset.htm","to_file":"sql-reset.html"},"sections":{"added":["diagnostics","examples"],"changed":["description","compatibility"],"removed":["usage"]},"status":"changed","synopsis":null,"to":"7.1"},{"from":"7.1","purpose_changed":true,"renamed":null,"sections":{"added":[],"changed":["compatibility"],"removed":[]},"status":"changed","synopsis":{"added":["RESET ALL"],"removed":[]},"to":"7.2"},{"from":"7.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","examples"],"removed":[]},"status":"changed","synopsis":null,"to":"7.3"},{"from":"7.3","purpose_changed":true,"renamed":null,"sections":{"added":["parameters"],"changed":["description","examples"],"removed":["diagnostics"]},"status":"changed","synopsis":{"added":["RESET name"],"removed":["RESET variable"]},"to":"7.4"},{"from":"7.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["examples"],"removed":[]},"status":"changed","synopsis":null,"to":"8.0"},{"from":"8.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"8.1"},{"from":"8.1","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":{"added":["RESET configuration_parameter"],"removed":["RESET name"]},"to":"8.2"},{"from":"8.2","purpose_changed":false,"renamed":null,"sections":{"added":["see_also"],"changed":["description","parameters","examples"],"removed":[]},"status":"changed","synopsis":null,"to":"8.3"},{"from":"9.5","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"9.6"},{"from":"9.6","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"10"},{"from":"13","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"14"},{"from":"16","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"17"}],"content_hash":"f3e8c278dee2f10692f38282ba108e83a0e1cc0d90bd470d4ccc959d1eb480cf","editorial":{},"first_version":"6.4","group":"session","imported_at":"2026-09-30T17:43:39.474615+08:00","last_version":"20","name":"RESET","object":"","position":14003,"present_in":["6.4","6.5","7.0","7.1","7.2","7.3","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"purpose":"restore the value of a run-time parameter to the default value","purpose_zh":"","related":["set","show"],"slug":"reset","source_rev":"a709ab85","synopsis":"RESET configuration_parameter\nRESET ALL","verb":"RESET"}},"Definition":{"Collection":"sql","Key":"reset","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"reset","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-RESET","file":"sql-reset.html","lang":"en","name":"RESET","purpose":"restore the value of a run-time parameter to the default value","purpose_zh":"","related":["set","show"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e restores run-time parameters to their default values. \u003ccode class=\"command\"\u003eRESET\u003c/code\u003e is an alternative spelling for\u003c/p\u003e\u003cpre class=\"synopsis\"\u003eSET \u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e TO DEFAULT\n\u003c/pre\u003e\u003cp\u003eRefer to \u003ca href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e for details.\u003c/p\u003e\u003cp\u003eThe default value is defined as the value that the parameter would have had, if no \u003ccode class=\"command\"\u003eSET\u003c/code\u003e had ever been issued for it in the current session. The actual source of this value might be a compiled-in default, the configuration file, command-line options, or per-database or per-user default settings. This is subtly different from defining it as \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ethe value that the parameter had at session start\u003c/span\u003e”\u003c/span\u003e, because if the value came from the configuration file, it will be reset to whatever is specified by the configuration file now. See \u003ca href=\"/docs/18/runtime-config.html\" title=\"Chapter 19. Server Configuration\"\u003eChapter 19\u003c/a\u003e for details.\u003c/p\u003e\u003cp\u003eThe transactional behavior of \u003ccode class=\"command\"\u003eRESET\u003c/code\u003e is the same as \u003ccode class=\"command\"\u003eSET\u003c/code\u003e: its effects will be undone by transaction rollback.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eName of a settable run-time parameter. Available parameters are documented in \u003ca href=\"/docs/18/runtime-config.html\" title=\"Chapter 19. Server Configuration\"\u003eChapter 19\u003c/a\u003e and on the \u003ca href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e reference page.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eALL\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eResets all settable run-time parameters to default values.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eSet the \u003ccode class=\"varname\"\u003etimezone\u003c/code\u003e configuration variable to its default value:\u003c/p\u003e\u003cpre class=\"screen\"\u003eRESET timezone;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e is a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e extension.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/set/?v=18\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/show/?v=18\" title=\"SHOW\"\u003e\u003cspan class=\"refentrytitle\"\u003eSHOW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"RESET \u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e\nRESET ALL","synopsis_text":"RESET configuration_parameter\nRESET ALL"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"reset","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"RESET","Summary":"将一个运行时参数的值恢复为默认值","BodyHTML":"\u003cpre\u003eRESET configuration_parameter\nRESET ALL\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eRESET\u003c/code\u003e将运行时参数恢复为其默认值。\u003ccode\u003eRESET\u003c/code\u003e是\u003c/p\u003e\u003cpre\u003eSET \u003cem\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e TO DEFAULT\n\u003c/pre\u003e\u003cp\u003e的另一种拼写。详见\u003ca href=\"/docs/18/sql-set.html\" title=\"SET\" rel=\"nofollow\"\u003e\u003cspan\u003eSET\u003c/span\u003e\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e默认值指的是：在当前会话中，如果从未对该参数执行过\u003ccode\u003eSET\u003c/code\u003e，它本应具有的值。该值的实际来源可能是编译时内置的默认值、配置文件、命令行选项，或者针对特定数据库或特定用户的默认设置。这与将其定义为\u003cspan\u003e“\u003cspan\u003e该参数在会话开始时的值\u003c/span\u003e”\u003c/span\u003e略有不同，因为如果该值来自配置文件，那么它会被重置为配置文件当前指定的值。详见\u003ca href=\"/docs/18/runtime-config.html\" rel=\"nofollow\"\u003e第 19 章\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e\u003ccode\u003eRESET\u003c/code\u003e的事务行为和\u003ccode\u003eSET\u003c/code\u003e相同：它的效果会在事务回滚时被撤销。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e可设置的运行时参数名称。可用参数见\u003ca href=\"/docs/18/runtime-config.html\" rel=\"nofollow\"\u003e第 19 章\u003c/a\u003e以及\u003ca href=\"/docs/18/sql-set.html\" title=\"SET\" rel=\"nofollow\"\u003e\u003cspan\u003eSET\u003c/span\u003e\u003c/a\u003e参考页。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eALL\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e将所有可设置的运行时参数重置为默认值。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e将\u003ccode\u003etimezone\u003c/code\u003e配置参数设置为其默认值：\u003c/p\u003e\u003cpre\u003eRESET timezone;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eRESET\u003c/code\u003e是一种 \u003cspan\u003ePostgreSQL\u003c/span\u003e扩展。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/set/?v=18\" title=\"SET\" rel=\"nofollow\"\u003e\u003cspan\u003eSET\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/show/?v=18\" title=\"SHOW\" rel=\"nofollow\"\u003e\u003cspan\u003eSHOW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"d27d4f0e32bdb0a2f422ec93da93c9458fb05a96328adc300d1e16d8ef75bf25","Payload":{"purpose_zh":"将一个运行时参数的值恢复为默认值","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e将运行时参数恢复为其默认值。\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e是\u003c/p\u003e\u003cpre class=\"synopsis\"\u003eSET \u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e TO DEFAULT\n\u003c/pre\u003e\u003cp\u003e的另一种拼写。详见\u003ca href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e默认值指的是：在当前会话中，如果从未对该参数执行过\u003ccode class=\"command\"\u003eSET\u003c/code\u003e，它本应具有的值。该值的实际来源可能是编译时内置的默认值、配置文件、命令行选项，或者针对特定数据库或特定用户的默认设置。这与将其定义为\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e该参数在会话开始时的值\u003c/span\u003e”\u003c/span\u003e略有不同，因为如果该值来自配置文件，那么它会被重置为配置文件当前指定的值。详见\u003ca href=\"/docs/18/runtime-config.html\" title=\"第 19 章 服务器配置\"\u003e第 19 章\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e的事务行为和\u003ccode class=\"command\"\u003eSET\u003c/code\u003e相同：它的效果会在事务回滚时被撤销。\u003c/p\u003e","key":"description","title":"描述"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e可设置的运行时参数名称。可用参数见\u003ca href=\"/docs/18/runtime-config.html\" title=\"第 19 章 服务器配置\"\u003e第 19 章\u003c/a\u003e以及\u003ca href=\"/docs/18/sql-set.html\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e参考页。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eALL\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e将所有可设置的运行时参数重置为默认值。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e将\u003ccode class=\"varname\"\u003etimezone\u003c/code\u003e配置参数设置为其默认值：\u003c/p\u003e\u003cpre class=\"screen\"\u003eRESET timezone;\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRESET\u003c/code\u003e是一种 \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e扩展。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/set/?v=18\" title=\"SET\"\u003e\u003cspan class=\"refentrytitle\"\u003eSET\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/show/?v=18\" title=\"SHOW\"\u003e\u003cspan class=\"refentrytitle\"\u003eSHOW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"RESET \u003cem class=\"replaceable\"\u003e\u003ccode\u003econfiguration_parameter\u003c/code\u003e\u003c/em\u003e\nRESET ALL","synopsis_text":"RESET configuration_parameter\nRESET ALL"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","6.4","6.5","7.0","7.1","7.2","7.3","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}