From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Foreign Key 'walker'? |
Date: | 2008-11-18 15:47:49 |
Message-ID: | gfuo36$r28$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Erwin Moller, 18.11.2008 15:47:
> Suppose I want to delete a record in tblnr1.
> Does Postgres has some command/procedure/function to list tables that
> have FK constraints on that table (tblnr1)
That could be resolved with a query against the INFORMATION_SCHEMA
Something like
SELECT c.table_name || ' references ' || tu.table_name
FROM information_schema.table_constraints c
JOIN information_schema.constraint_table_usage tu
ON (c.constraint_name = tu.constraint_name AND c.table_schema = tu.table_schema)
WHERE c.constraint_type = 'FOREIGN KEY';
> and lists also the tables that have a FK constraint on tables that have
> a FK constraint on the first? etc.
> So I would like some kind of FK 'walker'.
That would be your front-end that displays that (or some nested self-join using the above statement)
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Moller | 2008-11-18 16:01:49 | Re: Foreign Key 'walker'? |
Previous Message | tv | 2008-11-18 15:06:16 | Re: Slow queries when ORDER BY ... DESC with table inheritance (no index scan backwards) |