Support setting session TIMEZONE

[villisco]

Please add option to set the db sessions timezone (inside connection string maybe?).

Example:

SET TIME ZONE 'UTC'

TIMESTAMP WITH TIME ZONE (type: timestamptz) columns in postgres use the db session timezone for date conversion.

This is needed because INSERT'ing data on DST (Daylight Saving Time) period can have some strange timestamp converting behaviors.

[alejandrodnm]

Hey @villisco we don't have a lot of bandwidth right now to add new features, but we welcome PRs :)

[MetalBlueberry]

Hello @villisco

By any chance, do you have an example of this strange behaviors?

[MetalBlueberry]

BTW using the connection string you can change the options, so setting options=-c TimeZone=UTC is equivalent to doing SET TIME ZONE 'UTC'; after connecting.

Here is a simple example connection string with psql

psql "host=$PG_HOST port=$PG_PORT dbname=$PG_DATABASE user=$PG_USER password=$PG_PASSWORD sslmode=require options='-c TimeZone=New_York'"