Re: psql's describe command (for sequences) output improvement

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