From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to get fy info from the parent table |
Date: | 2008-07-04 14:43:48 |
Message-ID: | 200807041743.48920.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Στις Friday 04 July 2008 16:57:20 ο/η Jessica Richard έγραψε:
> Could some one tell me how to check this pk/fy thing please?
>
smth like
SELECT kid.relname as "KID",c.confrelid,c.conkey,c.confkey,f.relname as "DAD"
FROM pg_catalog.pg_constraint c,pg_catalog.pg_class f,pg_catalog.pg_class kid WHERE
c.contype = 'f' AND c.confrelid = f.oid AND c.conrelid=kid.oid AND f.relname='vessels';
could be your friend. substitute vessels with your "DAD" table, to find the kids.
> >From the parent table, I can see only the primary key there, now I wan to know how many and what other foreign keys are referencing this primary key... did this check long time ago and totally forgot how I did it then....
>
> Thanks a log,
> Jessica
>
>
>
>
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-07-04 15:49:56 | Re: changing sequence in serial field |
Previous Message | Jessica Richard | 2008-07-04 13:57:20 | how to get fy info from the parent table |