Re: Show stored function code

Oh, I'm sorry.

My function are written in sql and plpgsql.

Rergards.

Mephysto

On 28 March 2012 16:01, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Wed, Mar 28, 2012 at 8:33 AM, mephysto <mephystoonhell(at)gmail(dot)com>
> wrote:
> > Hello,
> > I'm trying to execute search in my stored functions code, but I have some
> > difficulties. I'm using postgres 9.1.3, and if I execeute this query
> >
> > SELECT prosrc FROM pg_proc WHERE proname = <function name>;
> >
> > I retrieve an empty column for all my custom stored functions.
> >
> > Are I committing some errors?
> > Is there an alternative way to achieve my goal?
>
> That should work. What language are your functions written in?
>
> merlin
>