BUG #18145: In psql, \d does not output in expanded format
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #18145: In psql, \d does not output in expanded format |
| Дата | |
| Msg-id | 18145-5da930760e745493@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #18145: In psql, \d does not output in expanded format
|
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: