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

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: current version: Patch - Have psql show current values
Date: 2006-05-06 03:50:25
Message-ID: 445C1D01.2050808@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-05-06 03:56:06 Re: current version: Patch - Have psql show current values
Previous Message Bruce Momjian 2006-05-06 02:52:03 Re: current version: Patch - Have psql show current values

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-05-06 03:56:06 Re: current version: Patch - Have psql show current values
Previous Message Bruce Momjian 2006-05-06 02:52:03 Re: current version: Patch - Have psql show current values