Обсуждение: BUG #18145: In psql, \d does not output in expanded format
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
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