Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-09-05 Thread Bruce Momjian
On Thu, Sep 4, 2014 at 01:19:31PM -0400, Bruce Momjian wrote: > Uh, not sure what I was thinking --- strftime() is the way to go. Here > is the new output: > > ; > ; Archive created at 2014-09-04 13:00:15 -0400 <--- > ; dbname: test > ; TOC Entries: 8 > ;

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-09-04 Thread Bruce Momjian
On Wed, Sep 3, 2014 at 08:33:31PM -0400, Bruce Momjian wrote: > I can't seem to find a way to get the timezone offset via C; see: > > > http://stackoverflow.com/questions/635780/why-does-glibc-timezone-global-not-agree-with-system-time-on-dst > > On Linux, do 'man timezone' for details.

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-09-03 Thread Bruce Momjian
On Thu, Sep 4, 2014 at 12:02:19PM +1200, Gavin Flower wrote: > I would prefer the date in a sane numeric format to the left of the > time (similar to what I suggested above), easier to sort (if a sort > is required) - it is also easier to use regular expressions to > select statement in an arbitra

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-09-03 Thread Gavin Flower
On 04/09/14 08:13, Bruce Momjian wrote: On Thu, May 1, 2014 at 12:09:34PM -0400, Bruce Momjian wrote: 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 M

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-09-03 Thread Bruce Momjian
On Thu, May 1, 2014 at 12:09:34PM -0400, Bruce Momjian wrote: > 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 tabl

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-05-01 Thread Bruce Momjian
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

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-04-30 Thread Gavin Flower
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:

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-04-30 Thread Bruce Momjian
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 e

Re: [HACKERS] Display of timestamp in pg_dump custom format

2014-04-30 Thread Gavin Flower
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 t

[HACKERS] Display of timestamp in pg_dump custom format

2014-04-30 Thread Bruce Momjian
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? -- Bruce Momjian