Re: how to show time zone with numerical offset in CSV log? - Mailing list pgsql-general

Michael Zoet <Michael.Zoet@zoet.de> writes:
> Is there a way to convince Postgres to write the date/time with
> numerical time zone values to the log files?

Try something like

log_timezone = '<-0400>+4'

See the discussion of POSIX timezone names here:
http://www.postgresql.org/docs/9.4/static/datatype-datetime.html#DATATYPE-TIMEZONES

            regards, tom lane