Re: current version: Patch - Have psql show current values - Mailing list pgsql-patches

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/