From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | robert(dot)nilsson(dot)123(at)gmail(dot)com |
Subject: | BUG #18145: In psql, \d does not output in expanded format |
Date: | 2023-10-03 03:39:48 |
Message-ID: | 18145-5da930760e745493@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18145
Logged by: Robert Nilsson
Email address: robert(dot)nilsson(dot)123(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-10-03 13:37:45 | Re: BUG #18145: In psql, \d does not output in expanded format |
Previous Message | DataSelfService Srl | 2023-10-02 18:38:22 | Re: BUG #18142: strange behaviour of "UPDATE" with id_encode() |