PostgreSQL SET

From wikieduonline
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[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: