[HACKERS] Re: proposal - psql: possibility to specify sort for describecommands, when size is printed - Mailing list pgsql-hackers

From Pavel Stehule
Subject [HACKERS] Re: proposal - psql: possibility to specify sort for describecommands, when size is printed
Date
Msg-id CAFj8pRASZxag-r9epsqj-AMw6osGmui56NDdZR3fkd=epem+uQ@mail.gmail.com
Whole thread Raw
In response to [HACKERS] proposal - psql: possibility to specify sort for describe commands,when size is printed  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Hi

2017-02-23 12:17 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:
Hi

Currently is not possible to control sort columns for \d* commands. Usually schema and table name is used. Really often task is collect the most big objects in database. "\dt+, \di+" shows necessary information, but not in practical order.

Instead introduction some additional flags to backslash commands, I propose a special psql variable that can be used for specification of order used when some plus command is used.

some like

set EXTENDED_DESCRIBE_SORT size_desc
\dt+
\l+
\di+

Possible variants: schema_table, table_schema, size_desc, size_asc

Comments, notes?

here is a patch

Regards

Pavel
 

Regards

Pavel

Attachment

pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: [HACKERS] Checksums by default?
Next
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] snapbuild woes