Re: PLPGSQL function to search function source for a list of terms - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: PLPGSQL function to search function source for a list of terms
Date
Msg-id 4C939DEF.9070704@iol.ie
Whole thread Raw
In response to PLPGSQL function to search function source for a list of terms  (bricklen <bricklen@gmail.com>)
Responses Re: PLPGSQL function to search function source for a list of terms
List pgsql-general
On 17/09/2010 17:37, bricklen wrote:
> Here is a plpsql function I put together to search db functions in
> schemas other than pg_catalog and information_schema. Not the greatest
> of coding, but it might help someone else trying to solve the same
> issue I was having: to search all public functions for a list of
> terms. Sample usage is below the code, as are some sample results.

That could be pretty useful - why don't you put it on the wiki?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: PLPGSQL function to search function source for a list of terms
Next
From: Aram Fingal
Date:
Subject: Re: Transposing rows and columns