pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how to get fy info from the parent table 2+ messages / 2 participants [nested] [flat]
* how to get fy info from the parent table @ 2008-07-04 13:57 Jessica Richard <rjessil@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: Jessica Richard @ 2008-07-04 13:57 UTC (permalink / raw) To: pgsql-admin Could some one tell me how to check this pk/fy thing please? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to get fy info from the parent table @ 2008-07-04 14:43 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Jessica Richard <rjessil@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Achilleas Mantzios @ 2008-07-04 14:43 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-04 14:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-07-04 13:57 how to get fy info from the parent table Jessica Richard <rjessil@yahoo.com> 2008-07-04 14:43 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox