Greetings!
Can anyone suggest a query that will tell me the names of all functions
(both trigger and normal) that contain a given string of text?
Here's what happened:
My company's database has a table named charge and a view named
availcharges that returns all charges that are available.
On Thu, Feb 19, 2009 at 12:46:41PM -0500, Rob Richardson wrote:
Can anyone suggest a query that will tell me the names of all functions
(both trigger and normal) that contain a given string of text?
assuming you mean pl/* functions, you can simply use:
select proname from pg_proc where prosrc
Thank you very much. It works, as I'm sure you knew.
But I have a further question. I've never seen the ~* operator
before, and searching for it in the docs and on Google did not return
any results I could find. What does it mean?
Thanks again!
RobR
--
Sent via pgsql-general mailing list
On Thu, Feb 19, 2009 at 01:27:23PM -0500, Rob Richardson wrote:
Thank you very much. It works, as I'm sure you knew.
But I have a further question. I've never seen the ~* operator
before, and searching for it in the docs and on Google did not return
any results I could find. What does it