|
Kris,
I'm assuming you dont want to do this, but
just in case you're not aware of the option - the JDBC API exposes this
information.
hth
dim
----- Original Message -----
Sent: Saturday, June 22, 2002 8:30
PM
Subject: [SQL] Obtaining primary key
information from pg system tables
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 foreign key (i dont need to know which table the foreign key
references at this point).
Which tables do i need reference, could anyone
provide an example query?
Kris
|
