Re: [HACKERS] SQL Query to get Column constraints

2003-04-03 Thread Tom Lane
"Steve" <[EMAIL PROTECTED]> writes: > What I need to know, is how to find out if a column is a primary, or part of > a primary key. I need to do this using sql. In 7.3 this is pretty easy: look in the pg_constraint table for a 'p' constraint for the table. If you find one, 'conkey' lists the col

[HACKERS] SQL Query to get Column constraints

2003-04-03 Thread Steve
Hi there, I have been through the postgres faq's, and read through the describe.c file. I can't seem to solve my problem. I am building an automatic file writer, that gives me information about each of my tables. What I need to know, is how to find out if a column is a primary, or part of a pr