Message-ID: <bb0b0ed72040d113a024b650205cb35409852bff.camel@cybertec.at>
Subject: Re: BUG #18145: In psql, \d does not output in expanded format
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: robert.nilsson.123@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Tue, 03 Oct 2023 15:37:45 +0200
In-Reply-To: <18145-5da930760e745493@postgresql.org>
References: <18145-5da930760e745493@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/bb0b0ed72040d113a024b650205cb35409852bff.camel%40cybertec.at>
Precedence: bulk

On Tue, 2023-10-03 at 03:39 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 16.0
> Operating system:=C2=A0=C2=A0 Ubuntu 11.4.0 (x86_64)
>=20
> Turn on expanded output
> database=3D> \x on
>=20
> Display the information about the table again:
> database=3D> \d test
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 Table "pg_temp_6.test"
> =C2=A0Column |=C2=A0 Type=C2=A0=C2=A0 | Collation | Nullable | Default
> --------+---------+-----------+----------+---------
> =C2=A0id=C2=A0=C2=A0=C2=A0=C2=A0 | integer |=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 |
>=20
> Expected to see output in expanded format, like this;
> Table "pg_temp_6.test"
> -[ RECORD 1 ]------
> Column=C2=A0=C2=A0=C2=A0 | id
> Type=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | integer
> Collation |
> Nullable=C2=A0 |
> Default=C2=A0=C2=A0 |
>=20
> 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