Bruce Momjian wrote:

> What fields do we want to show? Maybe the TODO item is not needed. Is
> this all we want to show?
>
IRC what we want is something like this.

regression=# \d abc
Sequence "public.abc"
Column | Type
--------------+---------
sequence_name | abc
last_value | 1
increment_by | 1
max_value | 9223372036854775807
min_value | 1
cache_value | 1
log_cnt | 1
is_cycled | f
is_called | f


Because "\d abc" doesn't show us any important information.

regression=# \d abc
Sequence "public.abc"
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


Last year, I made a patch for this but it was so ugly that I didn't send
to -patches. Maybe Bruce's solution (\x & select * from seq) could be
hardcoded in describe.c.

--
Euler Taveira de Oliveira
http://www.timbira.com/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq