blob: da4bf996e48b84e19e0d6d1ba4614765fc25a558 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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. "
|
