X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 23CB5D853B for ; Thu, 8 Sep 2005 05:03:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16062-08 for ; Thu, 8 Sep 2005 08:03:32 +0000 (GMT) Received: from web34405.mail.mud.yahoo.com (web34405.mail.mud.yahoo.com [66.163.178.154]) by svr1.postgresql.org (Postfix) with SMTP id E2254D82DA for ; Thu, 8 Sep 2005 05:03:30 -0300 (ADT) Received: (qmail 94286 invoked by uid 60001); 8 Sep 2005 08:03:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=c1Za6pOPon4bQgSv6lc0ZRZVJzJE+qzq3Po/CwnlL9OhHaUefQ1dIKyzPRA8NSJIA9q3Vnsa2vVbCeqRuYCIkaW+XFg5gUbkwuNenA2RIhyxIc//i/UUMhJqf7XTStPP+SkAfucA0eNBOmDIwF1AMXp6Ko7vLqAUy3jh2l0EDzQ= ; Message-ID: <20050908080327.94284.qmail@web34405.mail.mud.yahoo.com> Received: from [203.115.30.220] by web34405.mail.mud.yahoo.com via HTTP; Thu, 08 Sep 2005 01:03:26 PDT Date: Thu, 8 Sep 2005 01:03:26 -0700 (PDT) From: Thusitha Kodikara Subject: Relationship beween sequences (serial) and tables To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-907993953-1126166606=:72792" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.431 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, HTML_30_40=0.056, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/71 X-Sequence-Number: 18808 --0-907993953-1126166606=:72792 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I use Postgres 7.4.5 on Linux In many of my tables the primary key is bigserial for which sequences are automatcially generated. Through pg_catalog tables how can I find the relationship petween each table and its corresponding sequence ? Thanks. -Thusitha --------------------------------- Click here to donate to the Hurricane Katrina relief effort. --0-907993953-1126166606=:72792 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
 
I use Postgres 7.4.5 on Linux
 
In many of my tables the primary key is bigserial for which sequences are automatcially generated. Through pg_catalog tables how can I find the relationship petween each table and its corresponding sequence ?
 
Thanks.
 
-Thusitha


Click here to donate to the Hurricane Katrina relief effort. --0-907993953-1126166606=:72792--