From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: robert.nilsson.123@gmail.com
Subject: BUG #18145: In psql, \d does not output in expanded format
Date: Tue, 03 Oct 2023 03:39:48 +0000
Message-ID: <18145-5da930760e745493@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, robert.nilsson.123@gmail.com
Subject: Re: BUG #18145: In psql, \d does not output in expanded format
In-Reply-To: <18145-5da930760e745493@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox