Difference between revisions of "PostgreSQL SET"

From wikieduonline
Jump to navigation Jump to search
Line 14: Line 14:
 
  Output:
 
  Output:
 
  SET
 
  SET
 +
 +
[[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,pg_catalog;
  
 
== Related ==
 
== Related ==

Revision as of 11:28, 8 February 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

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

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

Related

See also

Advertising: