Re: [GENERAL] Search for restricting foreign keys

2005-01-25 Thread Florian G. Pflug
Michael Fuhr wrote: On Mon, Jan 24, 2005 at 08:35:45PM -0800, Benjamin Smith wrote: Is there a way in PG 7.3, given a field, to find out what other tables & records are linked to it via a foreign key? The pg_constraint table contains, among other things, foreign key constraints. By querying it an

Re: [GENERAL] Search for restricting foreign keys

2005-01-24 Thread Michael Fuhr
On Mon, Jan 24, 2005 at 08:35:45PM -0800, Benjamin Smith wrote: > Is there a way in PG 7.3, given a field, to find out what other tables & > records are linked to it via a foreign key? See the "System Catalogs" chapter in the documentation: http://www.postgresql.org/docs/7.3/static/catalogs.htm