Re: Display of timestamp in pg_dump custom format

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.

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