Re: Correction of how to use TimeZone by ControlFile(xlog.c) - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Date
Msg-id 46B35F22.7010005@dunslane.net
Whole thread Raw
In response to Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Gregory Stark <stark@enterprisedb.com>)
Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches

Gregory Stark wrote:
> Well even if we include the time in integer seconds-since-unix-epoch format it
> would be useful for a CSV data format.
>
>
>

That's probably the worst of all possible options. Two very common uses
of CSVlogs will be a) to load them into a PostgreSQL table and b) to
load them into a spreadsheet such as Excel. In both cases having a Unix
epoch time rather than a timestamp is likely to be very annoying.

Tom's idea of a log_timezone seems to make sense.

cheers

andrew



pgsql-patches by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Next
From: Tom Lane
Date:
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)