diff options
Diffstat (limited to 'src/bin/pgaccess/lib/help/set.hlp')
-rw-r--r-- | src/bin/pgaccess/lib/help/set.hlp | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/src/bin/pgaccess/lib/help/set.hlp b/src/bin/pgaccess/lib/help/set.hlp new file mode 100644 index 00000000000..da4bf996e48 --- /dev/null +++ b/src/bin/pgaccess/lib/help/set.hlp @@ -0,0 +1,54 @@ +.pgaw:Help.f.t insert end "SET" {bold} " will modify configuration parameters for variable during a session. + +" {} "Synopsis" {bold} " +" {} " +SET variable \{ TO | = \} \{ + 'value' | DEFAULT \} +SET TIME ZONE \{ 'timezone' | LOCAL | DEFAULT \}; +SET TRANSACTION ISOLATION LEVEL \{ READ COMMITTED | SERIALIZED \} + +" {code} "Usage" {bold} " +" {} " + --Set the style of date to ISO: + -- + SET DATESTYLE TO 'ISO'; + + + + --Enable GEQO for queries with 4 or more tables + -- + SET GEQO ON=4; + + + + --Set GEQO to default: + -- + SET GEQO = DEFAULT; + + + + --set the timezone for Berkeley, California: + SET TIME ZONE 'PST8PDT'; + + SELECT CURRENT_TIMESTAMP AS today; + + today + ---------------------- + 1998-03-31 07:41:21-08 + + + + --set the timezone for Italy: + SET TIME ZONE 'Europe/Rome'; + + SELECT CURRENT_TIMESTAMP AS today; + + today + ---------------------- + 1998-03-31 17:41:31+02 + +" {code} "Notes" {bold} " + +The SET variable statement is a Postgres language extension. + +Refer to SHOW and RESET to display or reset the current values. " |