Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

SHOW

Name

SHOW -- Displays the values of runtime variables.

Synopsis

SHOW 
name

Parameters

name

The name of a runtime variable.

Results

SHOW VARIABLE

The message returned after the SHOW command returns.

ERROR: Option ' name ' is not recognized

The error returned if the variable specified ( name ) does not exist.

ERROR: permission denied

The error returned if you do not have the permissions necessary to view this information.

NOTICE: Time zone is unknown

The notice returned if you request to show the TIMEZONE variable when the TZ or PGTZ environment variable is not set.

Description

Use the SHOW command to display the current settings for a specified runtime variable. The variables in question are specified using the SET command or automatically determined during server startup.

Examples

The following example displays the current transaction isolation level:

booktown=# 
SHOW TRANSACTION ISOLATION LEVEL;

NOTICE:  TRANSACTION ISOLATION LEVEL is SERIALIZABLE
SHOW VARIABLE

The next example displays the current date formatting style:

booktown=# 
SHOW DATESTYLE;

NOTICE:  DateStyle is ISO with US (NonEuropean) conventions
SHOW VARIABLE
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire