Thank You Guys, For your valuable suggestions. Out of the suggestion to investigate in to PG_depane was cumbersome , yes there is a view in information schema called information_schema.referential_constraints which gives same details in terms of foreign keys and primary keys and is usefull if u have strict nameing convention for foreign key and primary key in order to arive at table name.. Reece pgutil is excellent to get the all required information on foreign key tables and primary key tables. With Regards Ashish Karalkar --- Reece Hart <reece@xxxxxxxxx> wrote: > From: Ashish Karalkar <ashish_karalkar ( at > ) yahoo ( dot ) com> > * To: pgsql-general ( at ) postgresql > ( dot ) org > * Subject: Foreign Key Identification > * Date: Wed, 10 Jan 2007 08:23:28 > -0800 (PST) > > > ________________________________________________________________ > Hello All, > Is there any means to list out the foreign > key tables > which are liked with a primary key? > What i want to do is something as follows: > ... > select tablename from ? where Foreign key = > TableAPK > and this should list me > > > I needed to do something similar. I wrote some views > to do this and > packaged 'em up as something I call pgutils. See: > > http://archives.postgresql.org/pgsql-general/2006-11/msg00752.php > > http://harts.net/reece/pgutils/ > > > -Reece > > -- > Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0 > ./universe -G 6.672e-11 -e 1.602e-19 -protonmass > 1.673e-27 -uspres bush > kernel warning: universe consuming too many > resources. Killing. > universe killed due to catastrophic leadership. Try > -uspres carter. > > ____________________________________________________________________________________ Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited
