| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Re: proposal - psql: possibility to specify sort for describe commands, when size is printed |
| Date: | 2017-09-22 19:12:29 |
| Message-ID: | d5399a23-b9b5-be64-a195-ada7fdff7afb@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/22/17 09:16, Pavel Stehule wrote:
> Example: somebody set SORT_COLUMNS to schema_name value. This is
> nonsense for \l command
>
> Now, I am thinking so more correct and practical design is based on
> special mode, activated by variable
>
> PREFER_SIZE_SORT .. (off, asc, desc)
>
> This has sense for wide group of commands that can show size. And when
> size is not visible, then this option is not active.
Maybe this shouldn't be a variable at all. It's not like you'll set
this as a global preference. You probably want it for one command only.
So a per-command option might make more sense.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-09-22 19:13:10 | Shaky coding for vacuuming partitioned relations |
| Previous Message | Peter Eisentraut | 2017-09-22 19:06:11 | Re: DROP SUBSCRIPTION hangs if sub is disabled in the same transaction |