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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема [HACKERS] Re: proposal - psql: possibility to specify sort for describecommands, when size is printed
Дата
Msg-id CAFj8pRASZxag-r9epsqj-AMw6osGmui56NDdZR3fkd=epem+uQ@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] proposal - psql: possibility to specify sort for describe commands,when size is printed  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [HACKERS] Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ants Aasma
Дата:
Сообщение: Re: [HACKERS] Checksums by default?
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] snapbuild woes