From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: psql: Update \d sequence display |
Date: | 2017-09-29 17:43:52 |
Message-ID: | E1dxzKK-00074l-UV@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
psql: Update \d sequence display
For \d sequencename, the psql code just did SELECT * FROM sequencename
to get the information to display, but this does not contain much
interesting information anymore in PostgreSQL 10, because the metadata
has been moved to a separate system catalog.
This patch creates a newly designed sequence display that is not merely
an extension of the general relation/table display as it was previously.
Example:
PostgreSQL 9.6:
=> \d foobar
Sequence "public.foobar"
Column | Type | Value
---------------+---------+---------------------
sequence_name | name | foobar
last_value | bigint | 1
start_value | bigint | 1
increment_by | bigint | 1
max_value | bigint | 9223372036854775807
min_value | bigint | 1
cache_value | bigint | 1
log_cnt | bigint | 0
is_cycled | boolean | f
is_called | boolean | f
PostgreSQL 10 before this change:
=> \d foobar
Sequence "public.foobar"
Column | Type | Value
------------+---------+-------
last_value | bigint | 1
log_cnt | bigint | 0
is_called | boolean | f
New:
=> \d foobar
Sequence "public.foobar"
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
Reviewed-by: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/2a14b9609df1de4f2eb5a97aff674aaad033a7e6
Modified Files
--------------
src/bin/psql/describe.c | 189 +++++++++++++++++++--------------
src/test/regress/expected/identity.out | 7 ++
src/test/regress/expected/sequence.out | 13 +++
src/test/regress/sql/identity.sql | 2 +
src/test/regress/sql/sequence.sql | 4 +
5 files changed, 135 insertions(+), 80 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-09-29 17:59:45 | pgsql: pgbench: If we fail to send a command to the server, fail. |
Previous Message | Tom Lane | 2017-09-29 15:32:10 | pgsql: Marginal improvement for generated code in execExprInterp.c. |