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@xxxxxxxxxx
