Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2E6729FB21F for ; Mon, 2 Oct 2006 13:52:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25567-09 for ; Mon, 2 Oct 2006 13:52:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 138519FB2C3 for ; Mon, 2 Oct 2006 13:52:32 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1GUR19-0004PE-C7 for pgsql-sql@postgresql.org; Mon, 02 Oct 2006 18:51:47 +0200 Received: from ppp-82-135-12-120.dynamic.mnet-online.de ([82.135.12.120]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 Oct 2006 18:51:47 +0200 Received: from spam_eater by ppp-82-135-12-120.dynamic.mnet-online.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 Oct 2006 18:51:47 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: SEQUENCES Date: Mon, 02 Oct 2006 18:51:04 +0200 Lines: 19 Message-ID: References: <001801c6e641$6093f5d0$4700a8c0@TREEZANTHUS> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: ppp-82-135-12-120.dynamic.mnet-online.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.8.0.7) Gecko/20060909 Thunderbird/1.5.0.7 Mnenhy/0.7.4.0 In-Reply-To: <001801c6e641$6093f5d0$4700a8c0@TREEZANTHUS> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/6 X-Sequence-Number: 26395 Rodrigo Sakai wrote on 02.10.2006 18:39: > Hi all, > > > > I need to get all sequences and their respective current values! Is there > any catalog table or any other away to get this??? > > Quote from the manual at: http://www.postgresql.org/docs/8.1/static/catalog-pg-class.html "The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see also pg_index), sequences, views, composite types" Thomas