PostgreSQL SET

wikipedia:SET change a run-time parameter

• https://www.postgresql.org/docs/current/sql-set.html

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'; 

log_duration

SET SESSION AUTHORIZATION user_name

Output:
SET

ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;

Related

• Redis
• set
• PostgreSQL SET ROLE

See also

• PostgreSQL SET
• SET, PostgreSQL SET, SET ROLE, MariaDB SET