1 .\\" auto-generated by docbook2man-spec $Revision: 1.25 $
2 .TH "SHOW" "7" "2003-11-02" "SQL - Language Statements" "SQL Commands"
4 SHOW \- show the value of a run-time parameter
15 \fBSHOW\fR will display the current setting of
16 run-time parameters. These variables can be set using the
17 \fBSET\fR statement, by editing the
18 \fIpostgresql.conf\fR configuration file, through
19 the \fBPGOPTIONS\fR environmental variable (when using
20 \fBlibpq\fR or a \fBlibpq\fR-based
21 application), or through command-line flags when starting the
22 \fBpostmaster\fR. See the section called ``Run-time Configuration'' in the documentation for details.
26 The name of a run-time parameter. Available parameters are
27 documented in the section called ``Run-time Configuration'' in the documentation and on the SET [\fBset\fR(7)] reference page. In
28 addition, there are a few parameters that can be shown but not
33 Shows the server's version number.
36 Shows the server-side character set encoding. At present,
37 this parameter can be shown but not set, because the
38 encoding is determined at database creation time.
41 Shows the database's locale setting for collation (text
42 ordering). At present, this parameter can be shown but not
43 set, because the setting is determined at
47 Shows the database's locale setting for character
48 classification. At present, this parameter can be shown but
49 not set, because the setting is determined at
53 True if the current session authorization identifier has
59 Show the values of all configurations parameters.
62 The function \fBcurrent_setting\fR produces
63 equivalent output. See the section called ``Miscellaneous Functions'' in the documentation.
66 Show the current setting of the parameter DateStyle:
77 Show the current setting of the parameter geqo:
93 -------------------------------+---------------------------------------
94 australian_timezones | off
95 authentication_timeout | 60
96 checkpoint_segments | 3
101 wal_sync_method | fdatasync
107 The \fBSHOW\fR command is a
108 PostgreSQL extension.