Skip site navigation (1) Skip section navigation (2)

Re: TODO item: Have psql show current values for a sequence

From: daveg <daveg(at)sonic(dot)net>
To: "Dickson S(dot) Guedes" <guediz(at)gmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item: Have psql show current values for a sequence
Date: 2008-05-24 05:25:04
Message-ID: 20080524052504.GE2470@sonic.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Sat, May 24, 2008 at 12:27:16AM -0300, Dickson S. Guedes wrote:
> Hi all,
> 
> These patch implements the TODO item: Have psql show current values
> for a sequence.
> Comments are welcome.
> 
>           Sequence "public.foo_bar_seq"
> +---------------+---------+---------------------+
> |    Column     |  Type   |        Value        |
> +---------------+---------+---------------------+
> | sequence_name | name    | foo_bar_seq         |
> | last_value    | bigint  | 11                  |
> | start_value   | bigint  | 1                   |
> | increment_by  | bigint  | 1                   |
> | max_value     | bigint  | 9223372036854775807 |
> | min_value     | bigint  | 1                   |
> | cache_value   | bigint  | 1                   |
> | log_cnt       | bigint  | 31                  |
> | is_cycled     | boolean | f                   |
> | is_called     | boolean | t                   |
> +---------------+---------+---------------------+

Is it now the style to draw a complete box around /d* displays? Or can we
dispense with the top and bottom rows of dashes?

-dg

-- 
David Gould       daveg(at)sonic(dot)net      510 536 1443    510 282 0869
If simplicity worked, the world would be overrun with insects.

In response to

Responses

pgsql-hackers by date

Next:From: Yoshiyuki AsabaDate: 2008-05-24 09:55:23
Subject: Re: WITH RECURSIVE patch V0.1
Previous:From: Jaime CasanovaDate: 2008-05-24 05:19:05
Subject: Re: Extending grant insert on tables to sequences

pgsql-patches by date

Next:From: Yoshiyuki AsabaDate: 2008-05-24 09:55:23
Subject: Re: WITH RECURSIVE patch V0.1
Previous:From: Jaime CasanovaDate: 2008-05-24 05:19:05
Subject: Re: Extending grant insert on tables to sequences

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group