show(7) - f7

1SHOW()                           SQL Commands                           SHOW()
2
3
4

NAME

6       SHOW - show the value of a run-time parameter
7
8

SYNOPSIS

10       SHOW name
11       SHOW ALL
12
13

DESCRIPTION

15       SHOW  will  display  the  current setting of run-time parameters. These
16       variables can be set using the SET  statement,  by  editing  the  post‐
17       gresql.conf  configuration  file,  through  the PGOPTIONS environmental
18       variable (when using libpq or a libpq-based  application),  or  through
19       command-line flags when starting the postgres. See in the documentation
20       for details.
21

PARAMETERS

23       name   The name of a run-time parameter. Available parameters are docu‐
24              mented in in the documentation and on the SET [set(7)] reference
25              page. In addition, there are a few parameters that can be  shown
26              but not set:
27
28              SERVER_VERSION
29                     Shows the server's version number.
30
31              SERVER_ENCODING
32                     Shows the server-side character set encoding. At present,
33                     this parameter can be shown  but  not  set,  because  the
34                     encoding is determined at database creation time.
35
36              LC_COLLATE
37                     Shows  the  database's locale setting for collation (text
38                     ordering). At present, this parameter can  be  shown  but
39                     not  set,  because  the  setting  is determined at initdb
40                     time.
41
42              LC_CTYPE
43                     Shows the database's locale setting for character classi‐
44                     fication. At present, this parameter can be shown but not
45                     set, because the setting is determined at initdb time.
46
47              IS_SUPERUSER
48                     True if the current role has superuser privileges.
49
50       ALL    Show the values of all configuration parameters,  with  descrip‐
51              tions.
52

NOTES

54       The  function  current_setting  produces  equivalent output. See in the
55       documentation.
56

EXAMPLES

58       Show the current setting of the parameter DateStyle:
59
60       SHOW DateStyle;
61        DateStyle
62       -----------
63        ISO, MDY
64       (1 row)
65
66
67       Show the current setting of the parameter geqo:
68
69       SHOW geqo;
70        geqo
71       ------
72        on
73       (1 row)
74
75
76       Show all settings:
77
78       SHOW ALL;
79                     name              |            setting             |                                         description
80       --------------------------------+--------------------------------+----------------------------------------------------------------------------------------------
81        add_missing_from               | off                            | Automatically adds missing table references to FROM clauses.
82        archive_command                | unset                          | WAL archiving command.
83           .
84           .
85           .
86        work_mem                       | 1024                           | Sets the maximum memory to be used for query workspaces.
87        zero_damaged_pages             | off                            | Continues processing past damaged page headers.
88       (146 rows)
89
90

COMPATIBILITY

92       The SHOW command is a PostgreSQL extension.
93