Обсуждение: BUG #18145: In psql, \d does not output in expanded format

Поиск
Список
Период
Сортировка

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

От
PG Bug reporting form
Дата:
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


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

От
Laurenz Albe
Дата:
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