Hi, I want to know what is the best way to get all the keys(unique, primary, foreign, multiple) for a table in postgres, I actually found this query and i am not sure if it is the best way to get the keys info:
select r.relname as "Table", c.conname as "Constraint Name", contype as "Constraint Type", conkey as "Key Columns", confkey as "Foreign Columns", consrc as "Source" from pg_class r, pg_constraint c where r.oid=c.conrelid and relname='tablename'; And if the above query is good, how can I display in the output the column names that relates to the key. Can I use that query to get The multiple key info? or what is the best way to do so? I will really appreciate your help. Thanks, Noura Elhawary ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
