reset.7

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· 7 代码 · 共 52 行

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "RESET" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
RESET \- restore the value of a run-time parameter to the default value

.SH SYNOPSIS
.sp
.nf
RESET \fIconfiguration_parameter\fR
RESET ALL
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBRESET\fR restores run-time parameters to their
default values. \fBRESET\fR is an alternative
spelling for
.sp
.nf
SET \fIconfiguration_parameter\fR TO DEFAULT
.sp
.fi
Refer to SET [\fBset\fR(7)] for
details.
.PP
The default value is defined as the value that the parameter would
have had, had no \fBSET\fR 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 in the documentation for details.
.PP
See the \fBSET\fR reference page for details on the
transaction behavior of \fBRESET\fR.
.SH "PARAMETERS"
.TP
\fB\fIconfiguration_parameter\fB\fR
The name of a run-time parameter. See SET [\fBset\fR(7)] for a list.
.TP
\fBALL\fR
Resets all settable run-time parameters to default values.
.SH "EXAMPLES"
.PP
Set the geqo configuration variable to its default value:
.sp
.nf
RESET geqo;
.sp
.fi
.SH "COMPATIBILITY"
.PP
\fBRESET\fR is a PostgreSQL extension.