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

From Michael Zoet
Subject how to show time zone with numerical offset in CSV log?
Date
Msg-id 20150922120719.Horde.8A71NRR9O9iCjGojqroC_w1@server06.zoet.de
Whole thread Raw
Responses Re: how to show time zone with numerical offset in CSV log?
List pgsql-general
Hello everybody,

I am saving PostgreSQL log file data (CVS logs) with Logstash and
Elasticsearch. My problem with this is that the time zone value is
with the name of the time zone like

  2015-09-22 12:02:59.836 CEST

which Logstash can not process.

What Logstash needs are date/time stamps like

2015-09-22 12:02:59.836 +0200.

How can I setup Postgres to log with a numerical offset in the CSV
logs and not with the name of the time zone?

Any hints and links to the corresponding documentation would be appreciated.

Regards,
Michael






pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: pgsql-95 repo in rsync
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: how to show time zone with numerical offset in CSV log?