Array like a foreign key - Mailing list pgsql-general

From Cristian Custodio
Subject Array like a foreign key
Date
Msg-id 001201c2e1c6$fe930f60$fb01a8c0@ttcristian
Whole thread Raw
List pgsql-general
Hi,
 
I would like do build a select that could show me the constraints
and its columns.
 
I tried this way but it don't work.
select c.conname, c.contype, c.confkey,  a.attname
  from pg_constraint c inner join pg_attribute a on (a.attnum in c.confkey)
 
 
The problem is because the confkey is a array type.
 
How can I do that.
 
 Please,
 
Cristian

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: almost there on a design
Next
From: Greg Copeland
Date:
Subject: Re: [HACKERS] Postgresql performace question