Re: psql's describe command (for sequences) output improvement - Mailing list pgsql-hackers

From Peter Childs
Subject Re: psql's describe command (for sequences) output improvement
Date
Msg-id a2de01dd0712040647r21acbd3cy35941942b4df27b5@mail.gmail.com
Whole thread Raw
In response to psql's describe command (for sequences) output improvement  ("Aftab Hussain" <aftab.hussain@enterprisedb.com>)
Responses Re: psql's describe command (for sequences) output improvement  ("Aftab Hussain" <aftab.se@gmail.com>)
List pgsql-hackers


On 04/12/2007, Aftab Hussain <aftab.hussain@enterprisedb.com> wrote:

Hi all,

I have a patch which tries to improve the '\d some_sequence_name' command output in psql utility. Before sending the patch to pgsql-patches I just want to know your opinion whether the new output of the command is OK or it needs to be modified before sending it to pgsql-patches.

For comparison purpose, here is the output of the '\d some_sequence_name' command:

-- Say we have created a sequence named 'test_seq' already as CREATE SEQUENCE test_seq.

--
-- Output: before applying the patch.
--
testdb=# \d test_seq;
Sequence "public.test_seq"
    Column     |  Type  
---------------+---------
 sequence_name | name
 last_value    | bigint
 increment_by  | bigint
 max_value     | bigint
 min_value     | bigint
 cache_value   | bigint
 log_cnt       | bigint
 is_cycled     | boolean
 is_called     | boolean

--
-- Output: after applying the patch.
--
testdb=# \d test_seq;
                                  Sequence "public.test_seq"
 last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 1          | 1            | 9223372036854775807 | 1         | 1           | 1       | f         | f



Thanks in advance for your feedback(s).

--
Aftab.

Why?

is that not what

select * from test_seq;

does already.

\d command return meta data not data.

Peter Childs

pgsql-hackers by date:

Previous
From: "Aftab Hussain"
Date:
Subject: psql's describe command (for sequences) output improvement
Next
From: Simon Riggs
Date:
Subject: TOASTed size