By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

How to know column constraints via system catalog tables

P: n/a
Hi,

I need to query each column's constraint and name of a table in
postgreSQL v7.3.4 with a single SQL query but don't know how. Would
appreciate any pointers!

Thank you.

Regards,
Damon
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ok I realise now to look for it using the pg_constraint and pg_class.
But the conkey in pg_constraint uses int2[] datatype. So if I have a
primary key made up of 2 columns then the conkey can return something
like {1,2}. I wonder how can i store this in my C++ data type? Is
there an equivalent? Thank you.

so********@excite.com (Damon) wrote in message news:<15**************************@posting.google. com>...
Hi,

I need to query each column's constraint and name of a table in
postgreSQL v7.3.4 with a single SQL query but don't know how. Would
appreciate any pointers!

Thank you.

Regards,
Damon

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.