Re: current version: Patch - Have psql show current values

I am thinking we just add another column to the \d display for sequences
showing the current value.

---------------------------------------------------------------------------

Euler Taveira de Oliveira wrote:
> 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
>

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +