Re: Time measurement format - more human readable

How about, the format of psql duration can be set via some ...
backslash command or commdn line switch? And the default of course
remains the current behavior?

bogdan
> Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> > On 2014-09-28 20:32:30 -0400, Gregory Smith wrote:
> >> On 9/28/14, 7:49 AM, Bogdan Pilch wrote:
> >>> I have created a small patch to postgres source (in particular the
> >>> psql part of it) that modifies the way time spent executing the SQL
> >>> commands is printed out.
>
> >> There are already a wide range of human readable time interval output
> >> formats available in the database; see the list at http://www.postgresql.org/docs/current/static/datatype-datetime.html#INTERVAL-STYLE-OUTPUT-TABLE
>
> > He's talking about psql's \timing...
>
> Indeed. Still, it seems like this has more downside than upside.
> It seems likely to break some peoples' scripts, and where exactly
> is the groundswell of complaint that the existing format is
> unreadable? TBH, I've not heard even one complaint about that
> before today. On the other hand, the number of complaints we will
> get if we change the format is likely to be more than zero.
>
> regards, tom lane