show(7) - c6

1SHOW(7)                          SQL Commands                          SHOW(7)
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 server. See in the docu‐
20       mentation 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 database
40                     creation 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  database  cre‐
46                     ation time.
47
48              IS_SUPERUSER
49                     True if the current role has superuser privileges.
50
51       ALL    Show  the  values of all configuration parameters, with descrip‐
52              tions.
53

NOTES

55       The function current_setting produces equivalent  output;  see  in  the
56       documentation.   Also,  the  pg_settings  system view produces the same
57       information.
58

EXAMPLES

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

COMPATIBILITY

94       The SHOW command is a PostgreSQL extension.
95