set.hlp

来自「关系型数据库 Postgresql 6.5.2」· HLP 代码 · 共 55 行

.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. "