top of page
CerebroSQL

PostgreSQL:  

SET

SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }

Example

SET search_path TO my_schema, public;
SET datestyle TO postgres, dmy;
SET TIME ZONE 'PST8PDT';
SET TIME ZONE 'Europe/Rome';

bottom of page