Re: Foreign Key Identification

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(at)harts(dot)net> 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