NAME

RESET - 把一個運(yùn)行時參數(shù)值恢復(fù)為缺省值

SYNOPSIS

RESET name
RESET ALL

DESCRIPTION 描述

RESET 將運(yùn)行時參數(shù)恢復(fù)為缺省值。 RESET 是下面語句的一個變種

SET parameter TO DEFAULT

 請參考 SET [set(7)] 命令令獲取允許的變量值和缺省值的詳細(xì)信息。

 缺省值是定義成變量可以擁有的數(shù)值，并且在當(dāng)前會話中沒有用 SET 設(shè)置過。這個數(shù)值的實(shí)際源頭可能是編譯的缺省， postmaster 的配置文件，或者是命令行開關(guān)，或者是每數(shù)據(jù)庫或每用戶的缺省設(shè)置。 參閱 Section 16.4``Run-time Configuration'' 獲取細(xì)節(jié)。

 參閱 SET 手冊頁獲取有關(guān)RESET 的事務(wù)行為的細(xì)節(jié)。  

PARAMETERS 參數(shù)

name

 請參考 SET [set(7)] 語句獲取有關(guān)可用的參數(shù)的詳細(xì)說明。

ALL

 把所有運(yùn)行時參數(shù)設(shè)置為缺省值。

EXAMPLES 例子

 把 datestyle 重新設(shè)為缺省值：

RESET datestyle;

 把 geqo 重新設(shè)為缺省值：

RESET geqo;

COMPATIBILITY 兼容性

RESET 是 PostgreSQL 擴(kuò)展。  

#p#

NAME

RESET - restore the value of a run-time parameter to the default value

SYNOPSIS

RESET name
RESET ALL

DESCRIPTION

RESET restores run-time parameters to their default values. RESET is an alternative spelling for

SET parameter TO DEFAULT

Refer to SET [set(7)] for details.

The default value is defined as the value that the parameter would have had, had no SET 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. See the section called ``Run-time Configuration'' in the documentation for details.

See the SET reference page for details on the transaction behavior of RESET.  

PARAMETERS

name

The name of a run-time parameter. See SET [set(7)] for a list.

ALL

Resets all settable run-time parameters to default values.

EXAMPLES

Set DATESTYLE to its default value:

RESET datestyle;

Set GEQO to its default value:

RESET geqo;

COMPATIBILITY

RESET is a PostgreSQL extension.