Hi > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Michael Zoet > Sent: Dienstag, 22. September 2015 12:07 > To: pgsql-general@xxxxxxxxxxxxxx > Subject: how to show time zone with numerical offset in CSV log? > > 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? Not exactly the same format, but this may help: kofadmin@kofdb.localhost=> SET datestyle TO 'ISO'; SET kofadmin@kofdb.localhost=> select now(); now ---------------------------- 2015-09-22 12:53:38.123+02 (1 row) If you want the change to be persistent you can use: ALTER DATABASE database_name SET datestyle TO 'ISO'; And then reconnect to see the change. Bye Charles > > Any hints and links to the corresponding documentation would be appreciated. > > Regards, > Michael > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
