Relationship beween sequences (serial) and tables

From: Thusitha Kodikara <kthusi(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Relationship beween sequences (serial) and tables
Date: 2005-09-08 08:03:26
Message-ID: 20050908080327.94284.qmail@web34405.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Witney 2005-09-08 09:32:41 Re: pg_dump error... Follow up
Previous Message Pradeepkumar, Pyatalo (IE10) 2005-09-08 06:40:57 Please help - libpq API