Please don't top post, initial context is important, especially Tom's! :-)
(see my reply below)
On 01/10/14 03:52, Bogdan Pilch wrote:
> 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@2ndquadrant.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
>
As a user, your suggestion is fine by me.
Cheers,
Gavin