Postgres Pro
Downloads
Home   >   mailing lists

Relationship beween sequences (serial) and tables - Mailing list pgsql-admin

From Thusitha Kodikara
Subject Relationship beween sequences (serial) and tables
Date
Msg-id 20050908080327.94284.qmail@web34405.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Relationship beween sequences (serial) and tables  (Michael Fuhr <mike@fuhr.org>)
Re: Relationship beween sequences (serial) and tables  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Please help - libpq API
Next
From: Adam Witney
Date:
Subject: Re: pg_dump error... Follow up