Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 122872E0083; Sat, 24 May 2008 02:58:44 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69892-02; Sat, 24 May 2008 02:58:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from b.mail.sonic.net (b.mail.sonic.net [64.142.19.5]) by developer.postgresql.org (Postfix) with ESMTP id 32B8C2E0030; Sat, 24 May 2008 02:25:07 -0300 (ADT) Received: from newshell.sonic.net (bolt.sonic.net [208.201.242.19]) by b.mail.sonic.net (8.13.8.Beta0-Sonic/8.13.7) with ESMTP id m4O5P4ZA027642 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 23 May 2008 22:25:04 -0700 Received: from bolt.sonic.net (IDENT:Zv3RLgk6aNWdOUBTfgBk/X8hsviCqNNd@localhost.localdomain [127.0.0.1]) by newshell.sonic.net (8.13.6/8.12.1) with ESMTP id m4O5P4CQ008177; Fri, 23 May 2008 22:25:04 -0700 Received: (from daveg@localhost) by bolt.sonic.net (8.13.6/8.12.1/Submit) id m4O5P4Uk008176; Fri, 23 May 2008 22:25:04 -0700 Date: Fri, 23 May 2008 22:25:04 -0700 From: daveg To: "Dickson S. Guedes" Cc: pgsql-patches@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: TODO item: Have psql show current values for a sequence Message-ID: <20080524052504.GE2470@sonic.net> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/430 X-Sequence-Number: 6456 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@sonic.net 510 536 1443 510 282 0869 If simplicity worked, the world would be overrun with insects.