Can I search for text in a function?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Can I search for text in a function?
Date: 2008-08-11 20:01:57
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D9A2767@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
system. Is there a query I can use to find what function contains the
string "previous_charge"?

Thank you very much.

Robert D. Richardson
Product Engineer Software

<file:///t:/Sales/Images/Marketing%20Pictures/Logos/LOGOs%20from%2010th%
20Floor/RAD-CON%20Logo%20for%20Signature.jpg>
RAD-CON, Inc.
TECHNOLOGY: Innovative & Proven
Phone : +1.216.706.8905
Fax: +1.216.221.1135
Website: www.RAD-CON.com <http://www.rad-con.com/>
E-mail: rob(dot)richardson(at)RAD-CON(dot)com


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-08-11 20:44:34 Re: Unlinked files in PGDATA/base following unclean shutdown
Previous Message Vlad Kosilov 2008-08-11 19:43:45 Re: big database with very small dump !?