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 ha
From: Ashish Karalkar
* To: pgsql-general ( at ) postgresql ( dot ) org
* Subject: Foreign Key Identification
* Date: Wed, 10 Jan 2007 08:23:28 -0800 (PST)
He
am Wed, dem 10.01.2007, um 12:17:25 -0500 mailte Tom Lane folgendes:
> "A. Kretschmer" <[EMAIL PROTECTED]> writes:
> > am Wed, dem 10.01.2007, um 8:23:28 -0800 mailte Ashish Karalkar folgendes:
> >> Is there any means to list out the foreign key tables
> >> which are liked with a primary key?
>
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am Wed, dem 10.01.2007, um 8:23:28 -0800 mailte Ashish Karalkar folgendes:
>> Is there any means to list out the foreign key tables
>> which are liked with a primary key?
> Take a look into the pg_depend - table.
I think there's an information_schem
am Wed, dem 10.01.2007, um 8:23:28 -0800 mailte Ashish Karalkar folgendes:
> Hello All,
> Is there any means to list out the foreign key tables
> which are liked with a primary key?
>
> is there any way to get this?
Take a look into the pg_depend - table.
http://www.postgresql.org/docs/8.1/int
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:
TableA with primary key TableAPK
TableB with Foreign key TableAPK
TableC with Foreign Key TableAPK
Waht i want to get is
select tablename from ? wher