1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
.\" $Header: /cvsroot/pgsql/src/man/Attic/show.l,v 1.2 1997/08/26 17:00:23 momjian Exp $
.TH SHOW SQL 05/14/97 PostgreSQL PostgreSQL
.SH NAME
show \(em show run-time parameters for session
.SH SYNOPSIS
.nf
\fBshow\fR variable
.fi
.SH DESCRIPTION
.BR Show
will display the current configuration parameters for
.IR variable
during a session.
.PP
The session can be configured using
.IR set (l),
and values can be restored to the defaults using
.IR reset (l).
Parameters and values are case-insensitive.
.PP
See
.IR set (l)
for more information on available variables.
.SH EXAMPLES
.nf
tgl=> show DateStyle;
NOTICE:DateStyle is Postgres with US (NonEuropean) conventions
SHOW VARIABLE
tgl=> show GEQO;
NOTICE:GEQO is ON
SHOW VARIABLE
.fi
.SH "SEE ALSO"
pgbuiltin(3),
reset(l),
set(l).
.SH BUGS
TBD