Postgres Pro
Downloads
Home   >   mailing lists

List Functions and Code - Mailing list pgsql-general

From Rebecca Clarke
Subject List Functions and Code
Date
Msg-id CANY3h+SBQ-Xc6SoCEn5mT_C2VahinbsJ1_sXO3=t5yS70oLnSg@mail.gmail.com
Whole thread Raw
Responses Re: List Functions and Code  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: List Functions and Code  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: List Functions and Code  (David Johnston <polobo@yahoo.com>)
Re: List Functions and Code  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: tommaso
Date:
Subject: Re: postgres unable to start
Next
From: Adrian Klaver
Date:
Subject: Re: issue with pg_restore