Skip site navigation (1) Skip section navigation (2)

Getting Primary & Foreign Key Information?

From: Bernie Holmes <holmes(at)msu(dot)edu>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Getting Primary & Foreign Key Information?
Date: 2001-07-31 13:28:37
Message-ID: 3B66B285.3090907@msu.edu (view raw or flat)
Thread:
Lists: pgsql-general
How do I get primary and foreign key data for a table?

Are there Postgres functions return this information?

What tables should I join to pg_index and pg_trigger to get this 
information?

Thanks for any assistance.


Responses

pgsql-general by date

Next:From: Einar KarttunenDate: 2001-07-31 13:31:42
Subject: Re: Sequences and inheritance
Previous:From: Dave CramerDate: 2001-07-31 08:56:12
Subject: RE: Please Help JDBC Error!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group