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

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

From: "Dickson S(dot) Guedes" <guediz(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item: Have psql show current values for a sequence
Date: 2008-05-24 14:09:47
Message-ID: f0b79c6f0805240709j7019b159k9cb75f316a7a3256@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Sat, May 24, 2008 at 2:25 AM, daveg <daveg(at)sonic(dot)net> wrote:
> 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?

Hi Dave,

This box around the display is because I'm using \pset border 2.

-- 
[]s
Dickson S. Guedes
-------------------------------------
Projeto Colmeia - Curitiba - PR
+55 (41) 3254-7130 ramal: 27
http://makeall.wordpress.com/
http://pgcon.postgresql.org.br/
http://planeta.postgresql.org.br/

In response to

pgsql-hackers by date

Next:From: Decibel!Date: 2008-05-24 18:49:46
Subject: Re: Posible planner improvement?
Previous:From: Peter EisentrautDate: 2008-05-24 14:00:45
Subject: Re: May Commitfest is done!

pgsql-patches by date

Next:From: Hans-Juergen SchoenigDate: 2008-05-25 12:27:46
Subject: Re: [HACKERS] WITH RECURSIVE patch V0.1
Previous:From: David FetterDate: 2008-05-24 12:08:51
Subject: Updated patch (Re: WITH RECURSIVE patch V0.1)

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