From: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: psql's describe command (for sequences) output improvement |
Date: | 2007-12-04 14:47:05 |
Message-ID: | a2de01dd0712040647r21acbd3cy35941942b4df27b5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 04/12/2007, Aftab Hussain <aftab(dot)hussain(at)enterprisedb(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-12-04 16:31:14 | TOASTed size |
Previous Message | Andrew Dunstan | 2007-12-04 14:31:30 | Re: buildenv.pl/buildenv.bat |