List Functions and Code

From: Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: List Functions and Code
Date: 2011-07-28 13:31:32
Message-ID: CANY3h+SBQ-Xc6SoCEn5mT_C2VahinbsJ1_sXO3=t5yS70oLnSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I want to search and list all the functions in a database that reference a
particular table within its code. Is there a way to do this?

I can list all the functions from pg_proc, however there is nothing there
which provides the code of the function, so therefore I can't query if it
mentions a table. I've tried looking in information_schema.routines but this
unfortunately does not have it either.

Rebecca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-07-28 13:37:07 Re: issue with pg_restore
Previous Message tommaso 2011-07-28 12:35:35 Re: postgres unable to start