Re: split up psql \d Modifiers column

2016-10-28 5:30 GMT+02:00 Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com
>:

> I propose to change the psql \d output a bit, best shown with an example:
>
> \d persons3
> - Table "public.persons3"
> - Column | Type | Modifiers
> ---------+---------+------------------
> - id | integer | not null
> - name | text | default ''::text
> + Table "public.persons3"
> + Column | Type | Collation | Nullable | Default
> +--------+---------+-----------+----------+----------
> + id | integer | | not null |
> + name | text | | | ''::text
>
>
> The "Modifiers" column used to be "the rest", but now \d+ adds
> additional columns, so throwing these three things into one column makes
> less sense.
>
> Also, some parts of that column are currently marked as translatable,
> but it is not clear whether this is supposed to be an English
> description or SQL text. By reducing the column contents to just the
> data and moving the description to the column header, this weirdness is
> avoided.
>
> If you're worried about horizontal space, note that if a column has all
> three properties, this will actually save space because the words
> "collate" and "default" go away.
>
> Patch attached. Most of it is test output changes; the code changes are
> in src/bin/psql/describe.c.
>

has sense

+ 1

Pavel

>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>