Re: Display of timestamp in pg_dump custom format

On Thu, May  1, 2014 at 12:33:51PM +1200, Gavin Flower wrote:
> On 01/05/14 12:04, Bruce Momjian wrote:
> >On Thu, May  1, 2014 at 08:27:49AM +1200, Gavin Flower wrote:
> >>On 01/05/14 02:51, Bruce Momjian wrote:
> >>>The table of contents for pg_restore -l shows the time the archive was
> >>>made as local time (it uses ctime()):
> >>>
> >>>    ; Archive created at Wed Apr 30 10:03:28 2014
> >>>
> >>>Is this clear enough that it is local time?  Should we display this
> >>>better, perhaps with a time zone designation?
> >>>
> >>I think it would be good to include the time zone, as we are all
> >>very international these days - and in Australia, adjacent states
> >>have different dates for the summer time transition!
> >>
> >>Personally, I would like to see the date in the format 2014-04-30,
> >>but having the day of the week is good.
> >>
> >>Milliseconds might be useful, if you want to check logs files.
> >OK, I will work on it for 9.5.  Thanks.
> >
> So the it would then read something like:
> 
>         ; Archive created at Wed 2014-04-30 10:03:28.042 NZST
> 
> (but with the correct appropriate time zone designation)?

I think we would use a numeric offset.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +