Re: Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed
Date
Msg-id 20170405231020.dicmaah467wxaanp@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hi,

On 2017-03-11 13:06:13 +0100, Pavel Stehule wrote:
> 2017-03-10 15:45 GMT+01:00 Alexander Korotkov <a.korotkov@postgrespro.ru>:
> 
> > On Fri, Mar 10, 2017 at 5:10 PM, Peter Eisentraut <
> > peter.eisentraut@2ndquadrant.com> wrote:
> >
> >> On 2/24/17 16:32, Pavel Stehule wrote:
> >> >     set EXTENDED_DESCRIBE_SORT size_desc
> >> >     \dt+
> >> >     \l+
> >> >     \di+
> >> >
> >> >     Possible variants: schema_table, table_schema, size_desc, size_asc
> >>
> >> I can see this being useful, but I think it needs to be organized a
> >> little better.
> >>
> >> Sort key and sort direction should be separate settings.
> >>
> >
> > I agree.
> >
> > I'm not sure why we need to have separate settings to sort by schema
> >> name and table name.
> >
> >
> > I think sorting by schema name, object name makes sense for people, who
> > have objects of same name in different schemas.
> >
> 
> I am sending a updated version with separated sort direction in special
> variable
> 
> There is a question. Has desc direction sense for columns like schema or
> table name?
> 
> Using desc, asc for size is natural. But for tablename?

I think it's pretty clear that we don't have sufficient agreement on the
design, not to speak of an implementation for an agreed upon design, to
get this into v10.  The patch also has been submitted late in the v10
cycle, and has received attention.  I'm therefore moving it to the next
commitfest.

Regards,

Andres



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: scram and \password
Next
From: Andres Freund
Date:
Subject: Re: [GENERAL] C++ port of Postgres