Обсуждение: [MASSMAIL]Recursively trace all Foreign Key "referenced by" tables?

Поиск
Список
Период
Сортировка

[MASSMAIL]Recursively trace all Foreign Key "referenced by" tables?

От
Ron Johnson
Дата:
The attached PG function dba.get_fk_referenced_by() has been tested on PG 9.6 and 14.

A recursive bash function (also attached) calls the PG function, and displays the whole tree of tables that the table in question depends on.  Output also attached.

Is there a better way to do this?  (I'm limited to scripting languages and what can be installed from RPM files.)
Вложения