Difference between revisions of "PostgreSQL SET"

From wikieduonline
Jump to navigation Jump to search
Line 20: Line 20:
  
 
== See also ==
 
== See also ==
* {{sed}}
+
* {{set}}
 
* {{PostgreSQL}}
 
* {{PostgreSQL}}
  
 
[[Category: PostgreSQL]]
 
[[Category: PostgreSQL]]

Revision as of 10:20, 22 September 2022

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

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

Output:
SET

Related

See also

Advertising: