Type: | string |
Default: | GMT |
Context: | user |
Restart: | false |
Sets the time zone for displaying and interpreting time stamps. The built-in default is GMT
, but that is typically overridden in postgresql.conf; initdb will install a setting there corresponding to its system environment. See datatype-timezones for more information.
Recommendations
To avoid a lot of confusion, make sure this is set to your local timeszone. If the server covers multiple time zones, then this should be set on a ROLE or connection basis.
On StackOverflow
On pgsql-hackers
- Re: Allow logical replication to copy tables in binary format
- Tab completion for AT TIME ZONE
- Re: Question: Do we have a rule to use "PostgreSQL" and "
PostgreSQL " separately? - pg_crc32c_armv8.c:35:9: error: implicit declaration of function '__crc32cb' is invalid in C99
- Re: generate_series for timestamptz and time zone problem