Postgres Pro
Downloads
Home   >   mailing lists

[MASSMAIL]Recursively trace all Foreign Key "referenced by" tables? - Mailing list pgsql-general

From Ron Johnson
Subject [MASSMAIL]Recursively trace all Foreign Key "referenced by" tables?
Date
Msg-id CANzqJaBULUGh=NhEFmp4csTz3DygSVp4VDraeBx_2srhesgRfQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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.)
Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Question on trigger
Next
From: jack
Date:
Subject: [MASSMAIL]constant crashing