Difference between revisions of "PostgreSQL SET"

From wikieduonline
Jump to navigation Jump to search
 
(3 intermediate revisions by 2 users not shown)
Line 9: Line 9:
 
  [[SET TIME ZONE]] 'Europe/Rome';
 
  [[SET TIME ZONE]] 'Europe/Rome';
 
  [[SET SESSION]] [[log_statement]] TO 'all';  
 
  [[SET SESSION]] [[log_statement]] TO 'all';  
 +
 +
[[log_duration]]
  
 
  [[SET]] SESSION AUTHORIZATION user_name
 
  [[SET]] SESSION AUTHORIZATION user_name
Line 15: Line 17:
 
  SET
 
  SET
  
  [[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,pg_catalog;
+
  [[ALTER]] USER prometheus [[SET]] [[SEARCH_PATH]] TO prometheus,[[pg_catalog]];
  
 
== Related ==
 
== Related ==
Line 23: Line 25:
 
== See also ==
 
== See also ==
 
* {{PostgreSQL SET}}
 
* {{PostgreSQL SET}}
 +
* {{SET}}
 
* {{PostgreSQL}}
 
* {{PostgreSQL}}
  
 
[[Category: PostgreSQL]]
 
[[Category: PostgreSQL]]

Latest revision as of 15:09, 17 July 2023

wikipedia:SET change a run-time parameter

SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }

Examples[edit]

SET SESSION AUTHORIZATION 
SET TIME ZONE 'Europe/Rome';
SET SESSION log_statement TO 'all'; 
log_duration
SET SESSION AUTHORIZATION user_name

Output:
SET
ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;

Related[edit]

See also[edit]

Advertising: