Question about array data types - Mailing list pgsql-general

From mike.griffin@mygenerationsoftware.com
Subject Question about array data types
Date
Msg-id 3619.4.161.8.84.1087184259.squirrel@4.161.8.84
Whole thread Raw
List pgsql-general
If you look at this web page you'll see that pg_contraint has a column
named confkey[]. It's an array of type int2[] that maps back to
pg_attribute.attnum to get the columns involved in the foreign key, how do
I use these array types, I need to bind back to pg_attribute and get the
list of columns, do I need to pull that data back, parse it in my
application code and hit pg_attribute with an IN clause or something?


http://www.postgresql.org/docs/7.4/static/catalog-pg-constraint.html



pgsql-general by date:

Previous
From: "zuhans@iname.com"
Date:
Subject: backup and restore just with use of jdbc?
Next
From: "Najib Abi Fadel"
Date:
Subject: HTML output