Book Contents

Book Index

Next Topic

Home

SHOW

The SHOW command displays run-time parameters for the current session.

Syntax

SHOW { name | ALL }

Semantics

 

name

is one of:

  • DATESTYLE
  • TIMEZONE

ALL

shows all run-time parameters.

Notes

Examples

=> SHOW ALL;

name | setting

-----------------+------------

vertica_options | 0

datestyle | ISO, MDY

timezone | US/Eastern

search_path | "PUBLIC"

(4 rows)