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