Re: [GENERAL] Can I search for text in a function?

2008-08-12 Thread Sim Zacks
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try: select * from pg_proc where lower(prosrc) like '%previous_charge%'; Sim Rob Richardson wrote: Greetings! Sometimes I need to track down how something happens in the database our application relies on, but whatever's happening may be

[GENERAL] Can I search for text in a function?

2008-08-11 Thread Rob Richardson
Greetings! 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

Re: [GENERAL] Can I search for text in a function?

2008-08-11 Thread Klint Gore
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