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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>SHOW</title>
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
<link rel="up" href="sql-commands.html" title="SQL Commands">
<link rel="prev" href="sql-set-transaction.html" title="SET TRANSACTION">
<link rel="next" href="sql-start-transaction.html" title="START TRANSACTION">
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="refentry" lang="en">
<a name="sql-show"></a><div class="titlepage"></div>
<div class="refnamediv">
<h2>Name</h2>
<p>SHOW — show the value of a run-time parameter</p>
</div>
<a name="id789124"></a><div class="refsynopsisdiv">
<h2>Synopsis</h2>
<pre class="synopsis">SHOW <em class="replaceable"><code>name</code></em>
SHOW ALL</pre>
</div>
<div class="refsect1" lang="en">
<a name="id789147"></a><h2>Description</h2>
<p> <code class="command">SHOW</code> will display the current setting of
run-time parameters. These variables can be set using the
<code class="command">SET</code> statement, by editing the
<code class="filename">postgresql.conf</code> configuration file, through
the <code class="envar">PGOPTIONS</code> environmental variable (when using
<span class="application">libpq</span> or a <span class="application">libpq</span>-based
application), or through command-line flags when starting the
<code class="command">postmaster</code>. See <a href="runtime-config.html" title="Chapter17.Server Configuration">Chapter17, <i>Server Configuration</i></a> for details.
</p>
</div>
<div class="refsect1" lang="en">
<a name="id789209"></a><h2>Parameters</h2>
<div class="variablelist"><dl>
<dt><span class="term"><em class="replaceable"><code>name</code></em></span></dt>
<dd>
<p> The name of a run-time parameter. Available parameters are
documented in <a href="runtime-config.html" title="Chapter17.Server Configuration">Chapter17, <i>Server Configuration</i></a> and on the <a href="sql-set.html">SET</a> reference page. In
addition, there are a few parameters that can be shown but not
set:
</p>
<div class="variablelist"><dl>
<dt><span class="term"><code class="literal">SERVER_VERSION</code></span></dt>
<dd><p> Shows the server's version number.
</p></dd>
<dt><span class="term"><code class="literal">SERVER_ENCODING</code></span></dt>
<dd><p> Shows the server-side character set encoding. At present,
this parameter can be shown but not set, because the
encoding is determined at database creation time.
</p></dd>
<dt><span class="term"><code class="literal">LC_COLLATE</code></span></dt>
<dd><p> Shows the database's locale setting for collation (text
ordering). At present, this parameter can be shown but not
set, because the setting is determined at
<code class="command">initdb</code> time.
</p></dd>
<dt><span class="term"><code class="literal">LC_CTYPE</code></span></dt>
<dd><p> Shows the database's locale setting for character
classification. At present, this parameter can be shown but
not set, because the setting is determined at
<code class="command">initdb</code> time.
</p></dd>
<dt><span class="term"><code class="literal">IS_SUPERUSER</code></span></dt>
<dd><p> True if the current session authorization identifier has
superuser privileges.
</p></dd>
</dl></div>
<p>
</p>
</dd>
<dt><span class="term"><code class="literal">ALL</code></span></dt>
<dd><p> Show the values of all configuration parameters, with descriptions.
</p></dd>
</dl></div>
</div>
<div class="refsect1" lang="en">
<a name="id789343"></a><h2>Notes</h2>
<p> The function <code class="function">current_setting</code> produces
equivalent output. See <a href="functions-admin.html" title="9.20.System Administration Functions">Section9.20, “System Administration Functions”</a>.
</p>
</div>
<div class="refsect1" lang="en">
<a name="id789364"></a><h2>Examples</h2>
<p> Show the current setting of the parameter <code class="varname">DateStyle</code>:
</p>
<pre class="programlisting">SHOW DateStyle;
DateStyle
-----------
ISO, MDY
(1 row)</pre>
<p>
</p>
<p> Show the current setting of the parameter <code class="varname">geqo</code>:
</p>
<pre class="programlisting">SHOW geqo;
geqo
------
on
(1 row)</pre>
<p>
</p>
<p> Show all settings:
</p>
<pre class="programlisting">SHOW ALL;
name | setting | description
--------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
add_missing_from | off | Automatically adds missing table references to FROM clauses.
archive_command | unset | WAL archiving command.
australian_timezones | off | Interprets ACST, CST, EST, and SAT as Australian time zones.
.
.
.
work_mem | 1024 | Sets the maximum memory to be used for query workspaces.
zero_damaged_pages | off | Continues processing past damaged page headers.
(146 rows)</pre>
<p>
</p>
</div>
<div class="refsect1" lang="en">
<a name="id789421"></a><h2>Compatibility</h2>
<p> The <code class="command">SHOW</code> command is a
<span class="productname">PostgreSQL</span> extension.
</p>
</div>
<div class="refsect1" lang="en">
<a name="id789441"></a><h2>See Also</h2>
<span class="simplelist"><a href="sql-set.html">SET</a>, <a href="sql-reset.html">RESET</a></span>
</div>
</div></body>
</html>
|
