Re: Dependency tree to tie type/function deps to a table

On Wed, Dec 13, 2017 at 10:20 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Jeremy Finzel <finzelj(at)gmail(dot)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.