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

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

Regards

Pavel

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

Предыдущее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: [HACKERS] Make subquery alias optional in FROM clause
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] GUC for cleanup indexes threshold.