| From: | so_excited(at)excite(dot)com (Damon) |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org(dot)pgsql-novice"(at)postgresql(dot)org |
| Subject: | Re: How to know column constraints via system catalog tables |
| Date: | 2003-11-05 14:29:45 |
| Message-ID: | 159c8bc6.0311050629.a6337f@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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(at)excite(dot)com (Damon) wrote in message news:<159c8bc6(dot)0311050341(dot)3ed4c289(at)posting(dot)google(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Damon | 2003-11-05 14:34:22 | How to store pg_constraint's int2[] data type in C++ |
| Previous Message | Dave Smith | 2003-11-05 14:21:30 | System crash and trying to run vacuum getting errors |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Themistoklis Konstantinou | 2003-11-05 15:13:25 | |
| Previous Message | Manfred Koizar | 2003-11-05 14:02:18 | Re: selecting rows based on unique fields in a column |