Re: Foreign Key 'walker'?
От | Thomas Kellerer |
---|---|
Тема | Re: Foreign Key 'walker'? |
Дата | |
Msg-id | gfuo36$r28$1@ger.gmane.org обсуждение исходный текст |
Ответ на | Foreign Key 'walker'? (Erwin Moller <erwin@darwine.nl>) |
Ответы |
Re: Foreign Key 'walker'?
|
Список | 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
В списке pgsql-general по дате отправления: