DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=bSGB/0QvejO0AjTkV7QUe7PWNMUALKh55iMNcwxX5QLF3Gs1ys7VK0A8YcJedT+7nWQ6sT3WkvqvuCHJSKlaTmdIQyzJ3jZZEJHIRUAjXCT3NrjjTpyYk0TUggjWh+jlUp4OusxeG4BkKLTKMdCphPZm8JS8NhBRwfrPCKlbXeU=
	;
Message-ID: <20050817190650.93891.qmail@web51904.mail.yahoo.com>
Date: Wed, 17 Aug 2005 12:06:50 -0700 (PDT)
From: Roger Motorola <roger77_lb@yahoo.com>
Subject: Locating ( FKs ) References to a Primary Key
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi to all, 

Is there any means by which one can get all Foreign Keys (References) that
'point' to a certain Primary Key for a given table ?

For instance, let's consider those three tables:

(NOTE: table contents here are not deeply thought of...)

// employees table
create table emp
(id serial primary key, 
first_name varchar not null, 
last_name varchar not null, 
.....................etc.);

// employee address
create table emp_address
(emp_id integer references emp (id), 
city integer references city (id), 
primary key (emp_id, city), 
comments varchar not null);

// employee categories ()
create table emp_categories
(emp_id integer references emp (id), 
institution integer references institutions (id),
unique (emp_id, institution), 
category integer references categories (id), 
primary key (emp_id, institution, category), 
description varchar not null);


So, can we issue a query that gets all references to emp.id ?
which should yield here:
    emp_address.emp_id 
and emp_categories.emp_id


Thanks in advance, 
Roger Tannous.


____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs