pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18145: In psql, \d does not output in expanded format
2+ messages / 2 participants
[nested] [flat]
* BUG #18145: In psql, \d does not output in expanded format
@ 2023-10-03 03:39 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2023-10-03 03:39 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: robert.nilsson.123@gmail.com
The following bug has been logged on the website:
Bug reference: 18145
Logged by: Robert Nilsson
Email address: robert.nilsson.123@gmail.com
PostgreSQL version: 16.0
Operating system: Ubuntu 11.4.0 (x86_64)
Description:
psql client version is psql (16.0 (Ubuntu 16.0-1.pgdg22.04+1) on x86_64.
Connect to a database with psql from a terminal.
Create a temporary table
CREATE TEMP TABLE test test ( id integer );
Make sure expanded format is off
database=> \x off
Display information about the table:
database=> \d test
Table "pg_temp_6.test"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
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;
database=> \x off
database=> \dt test
List of relations
Schema | Name | Type | Owner
-----------+------+-------+-------
pg_temp_6 | test | table | user
(1 row)
database=> \x on
\dt test
List of relations
-[ RECORD 1 ]-----
Schema | pg_temp_6
Name | test
Type | table
Owner | user
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18145: In psql, \d does not output in expanded format
@ 2023-10-03 13:37 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2023-10-03 13:37 UTC (permalink / raw)
To: robert.nilsson.123@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-10-03 13:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-03 03:39 BUG #18145: In psql, \d does not output in expanded format PG Bug reporting form <noreply@postgresql.org>
2023-10-03 13:37 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox