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_excited@excite.com (Damon) wrote in message news:<159c8bc6.0311050341.3ed4c289@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