From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: how to get fy info from the parent table
Date: Fri, 4 Jul 2008 17:43:48 +0300
User-Agent: KMail/1.9.7
References: <191205.16325.qm@web56414.mail.re3.yahoo.com>
In-Reply-To: <191205.16325.qm@web56414.mail.re3.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200807041743.48920.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Friday 04 July 2008 16:57:20 =CE=BF/=CE=B7 Jessica=
 Richard =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Could some one tell me how to check this pk/fy thing please?
>

smth like=20
SELECT kid.relname as "KID",c.confrelid,c.conkey,c.confkey,f.relname as "DA=
D"=20
=46ROM pg_catalog.pg_constraint c,pg_catalog.pg_class f,pg_catalog.pg_class=
 kid WHERE=20
c.contype =3D 'f' AND c.confrelid =3D f.oid AND c.conrelid=3Dkid.oid AND f.=
relname=3D'vessels';

could be your friend. substitute vessels with your "DAD" table, to find the=
 kids.
=20
> >From the parent table, I can see only the primary key there, now I wan t=
o know how many and what other foreign keys are referencing this primary ke=
y... did this check long time ago and totally forgot how I did it then....
>=20
> Thanks a log,
> Jessica
>=20
>=20
>=20
>      =20


=2D-=20
Achilleas Mantzios