Re: Can you help me with this query?

That doesn't complile, I don't think you can use a nested select where a
column goes?  I get an error yelping about one of the select statements,
did you test it out?  I'm using pgAdmin and don't think that it is the
problem?


> How about:
>
> SELECT cl.relname as TABLE_NAME,
>         cr.relname as FK_TABLE_NAME,
>  (select array(select attname from pg_attribute
>   where attrelid = ct.conrelid
>   and attnum = any (ct.conkey))) AS TBL_ATTS,
>  (select array(select attname from pg_attribute
>   where attrelid = ct.confrelid
>   and attnum = any (ct.confkey))) AS FK_TBL_ATTS
> FROM pg_constraint ct
> JOIN pg_class cl ON cl.oid=conrelid
> JOIN pg_namespace nl ON nl.oid=cl.relnamespace
> JOIN pg_class cr ON cr.oid=confrelid
> JOIN pg_namespace nr ON nr.oid=cr.relnamespace
> LEFT OUTER JOIN pg_description des ON des.objoid=ct.oid
> WHERE contype='f';
>
> Note the function is no longer there ;-)
>
> Nick
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>