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

Reply via email to