'\" t .\" Title: SHOW .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2024 .\" Manual: PostgreSQL 16.2 Documentation .\" Source: PostgreSQL 16.2 .\" Language: English .\" .TH "SHOW" "7" "2024" "PostgreSQL 16.2" "PostgreSQL 16.2 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" SHOW \- show the value of a run\-time parameter .SH "SYNOPSIS" .sp .nf SHOW \fIname\fR SHOW ALL .fi .SH "DESCRIPTION" .PP \fBSHOW\fR will display the current setting of run\-time parameters\&. These variables can be set using the \fBSET\fR statement, by editing the postgresql\&.conf configuration file, through the \fBPGOPTIONS\fR environmental variable (when using libpq or a libpq\-based application), or through command\-line flags when starting the \fBpostgres\fR server\&. See Chapter\ \&20 for details\&. .SH "PARAMETERS" .PP \fIname\fR .RS 4 The name of a run\-time parameter\&. Available parameters are documented in Chapter\ \&20 and on the \fBSET\fR(7) reference page\&. In addition, there are a few parameters that can be shown but not set: .PP SERVER_VERSION .RS 4 Shows the server\*(Aqs version number\&. .RE .PP SERVER_ENCODING .RS 4 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\&. .RE .PP LC_COLLATE .RS 4 Shows the database\*(Aqs locale setting for collation (text ordering)\&. At present, this parameter can be shown but not set, because the setting is determined at database creation time\&. .RE .PP LC_CTYPE .RS 4 Shows the database\*(Aqs locale setting for character classification\&. At present, this parameter can be shown but not set, because the setting is determined at database creation time\&. .RE .PP IS_SUPERUSER .RS 4 True if the current role has superuser privileges\&. .RE .RE .PP ALL .RS 4 Show the values of all configuration parameters, with descriptions\&. .RE .SH "NOTES" .PP The function \fBcurrent_setting\fR produces equivalent output; see Section\ \&9.27.1\&. Also, the pg_settings system view produces the same information\&. .SH "EXAMPLES" .PP Show the current setting of the parameter \fIDateStyle\fR: .sp .if n \{\ .RS 4 .\} .nf SHOW DateStyle; DateStyle \-\-\-\-\-\-\-\-\-\-\- ISO, MDY (1 row) .fi .if n \{\ .RE .\} .PP Show the current setting of the parameter \fIgeqo\fR: .sp .if n \{\ .RS 4 .\} .nf SHOW geqo; geqo \-\-\-\-\-\- on (1 row) .fi .if n \{\ .RE .\} .PP Show all settings: .sp .if n \{\ .RS 4 .\} .nf SHOW ALL; name | setting | description \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- allow_system_table_mods | off | Allows modifications of the structure of \&.\&.\&. \&. \&. \&. xmloption | content | Sets whether XML data in implicit parsing \&.\&.\&. zero_damaged_pages | off | Continues processing past damaged page headers\&. (196 rows) .fi .if n \{\ .RE .\} .SH "COMPATIBILITY" .PP The \fBSHOW\fR command is a PostgreSQL extension\&. .SH "SEE ALSO" \fBSET\fR(7), \fBRESET\fR(7)