| PostgreSQL 8.1.8 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or through command-line flags when starting the postmaster. See Chapter 17 for details.
The name of a run-time parameter. Available parameters are documented in Chapter 17 and on the SET reference page. In addition, there are a few parameters that can be shown but not set:
Shows the server's version number.
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.
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 initdb time.
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 initdb time.
True if the current session authorization identifier has superuser privileges.
Show the values of all configuration parameters, with descriptions.
Show the current setting of the parameter DateStyle:
SHOW DateStyle; DateStyle ----------- ISO, MDY (1 row)
Show the current setting of the parameter geqo:
SHOW geqo; geqo ------ on (1 row)
Show all settings:
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)
No comments could be found for this page.
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
In order to submit a comment, you must have a community account.
* denotes required field