Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 26192475F24 for ; Sat, 22 Jun 2002 06:36:12 -0400 (EDT) Received: from rhenium.btinternet.com (rhenium.btinternet.com [194.73.73.93]) by postgresql.org (Postfix) with ESMTP id C1E544758A2 for ; Sat, 22 Jun 2002 06:34:41 -0400 (EDT) Received: from host213-123-38-48.in-addr.btopenworld.com ([213.123.38.48] helo=graveland) by rhenium.btinternet.com with smtp (Exim 3.22 #8) id 17LiE7-0000rZ-00 for pgsql-sql@postgresql.org; Sat, 22 Jun 2002 11:34:43 +0100 Message-ID: <009201c219d7$c6605420$30267bd5@graveland> Reply-To: "Kris" From: "Kris" To: Subject: Obtaining primary key information from pg system tables Date: Sat, 22 Jun 2002 11:30:04 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_008F_01C219E0.27921910" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200206/309 X-Sequence-Number: 8274 This is a multi-part message in MIME format. ------=_NextPart_000_008F_01C219E0.27921910 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am trying to generate some xml metadata from the pg system tables for my = java code generation utility. I have can get most information, but i would = like to be able to tell which column is a primary key or which one is a for= eign key (i dont need to know which table the foreign key references at thi= s point). Which tables do i need reference, could anyone provide an example query? Kris ------=_NextPart_000_008F_01C219E0.27921910 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I am trying to generate some xml metadata = from the=20 pg system tables for my java code generation utility. I have can get most= =20 information, but i would like to be able to tell which column is a primary = key=20 or which one is a foreign key (i dont need to know which table the foreign = key=20 references at this point).
 
Which tables do i need reference, could an= yone=20 provide an example query?
 
Kris
------=_NextPart_000_008F_01C219E0.27921910--