Re: Correction of how to use TimeZone by ControlFile(xlog.c)

Поиск
Список
Период
Сортировка

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 по дате отправления:

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Correction of how to use TimeZone by ControlFile(xlog.c)