aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/set.hlp
diff options
context:
space:
mode:
Diffstat (limited to 'src/bin/pgaccess/lib/help/set.hlp')
-rw-r--r--src/bin/pgaccess/lib/help/set.hlp54
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. "