PostgreSQL SET

From wikieduonline
Revision as of 11:28, 8 February 2023 by Brave (talk | contribs) (→‎Examples)
Jump to navigation Jump to search

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: