Re: Can I search for text in a function?

Rob Richardson wrote:
> Sometimes I need to track down how something happens in the database
> our application relies on, but whatever's happening may be buried in
> some old function that everybody here has forgotten about long ago.
> IIRC, functions are stored internally merely as fields in a table
> owned by the system.  Is there a query I can use to find what function
> contains the string "previous_charge"?
>
select proname from pg_proc where prosrc ilike '%previous_charge%';

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au