On Wed, Dec 13, 2017 at 10:20 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Jeremy Finzel <finzelj@gmail.com> writes: > It looks like the very useful dependency tree shown when using DROP CASCADE > is written in C in dependency.c, but there is no way to leverage this > within Postgres to actually query an object's dependencies. Can we get > this somehow as a Postgres client in SQL?
Seems like you could build a query for that easily enough using a recursive union over pg_depend plus pg_describe_object() to produce text descriptions of the entries.
regards, tom lane
Jeremy ,
per Tom
>Seems like you could build a query...
Attached is the query that I use. Hope that helps you.
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.