subject:"\[GENERAL\] column refernce question"

Re: [GENERAL] column refernce question

2006-10-18 Thread Jonathan Hedstrom

Hugo wrote: > Hi, how can I know all the foreign key constrainst that references a > particular pk ? > You can try this: SELECT c_from.relname AS table, (SELECT attname FROM pg_catalog.pg_attribute a WHERE a.attrelid=c_from.oid AND attnum = array_to_string(conkey,',')) AS column FROM pg_catalog.p

[GENERAL] column refernce question

2006-10-18 Thread Hugo

Hi, how can I know all the foreign key constrainst that references a particular pk ?this is on postgres 8.1.4 on susethanks for any adviceHugo