Session level timezone in Postgres
You can set timezone at session level in Postgres using SET
.
It allows to override the server-level timezone for a specific session.
SET timezone = 'US/Pacific';
You can use the SELECT
statement to verify the current timezone by executing:
SELECT current_setting('timezone');
+-----------------+
| current_setting |
|-----------------|
| US/Pacific |
+-----------------+