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

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

Responses

Browse pgsql-bugs by date

  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()