Re: BUG #18145: In psql, \d does not output in expanded format

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: robert(dot)nilsson(dot)123(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18145: In psql, \d does not output in expanded format
Date: 2023-10-03 13:37:45
Message-ID: bb0b0ed72040d113a024b650205cb35409852bff.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, 2023-10-03 at 03:39 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 16.0
> Operating system:   Ubuntu 11.4.0 (x86_64)
>
> Turn on expanded output
> database=> \x on
>
> Display the information about the table again:
> database=> \d test
>               Table "pg_temp_6.test"
>  Column |  Type   | Collation | Nullable | Default
> --------+---------+-----------+----------+---------
>  id     | integer |           |          |
>
> Expected to see output in expanded format, like this;
> Table "pg_temp_6.test"
> -[ RECORD 1 ]------
> Column    | id
> Type      | integer
> Collation |
> Nullable  |
> Default   |
>
> The related command \dt works as expected;

I don't think that's a bug.

\dt just prints a result set, which is easy to render in expanded mode.

But \d prints many other things (indexes, foreign keys, storage parameters, ...),
and it is not clear how that should look in expanded mode.

Yours,
Laurenz Albe

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurenz Albe 2023-10-03 13:40:25 Re: BUG #18144: While i am intalling postgresql-12 repo,i am facing the below.i tried with dowload and install.
Previous Message PG Bug reporting form 2023-10-03 03:39:48 BUG #18145: In psql, \d does not output in expanded format