Re: Show stored function code - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Show stored function code
Date
Msg-id CAHyXU0yaT6wS2ce=njHKXnBaabYpst=YX4dk2bMmG8UJMYUDRw@mail.gmail.com
Whole thread Raw
In response to Show stored function code  (mephysto <mephystoonhell@gmail.com>)
Responses Re: Show stored function code  (Mephysto <mephystoonhell@gmail.com>)
List pgsql-novice
On Wed, Mar 28, 2012 at 8:33 AM, mephysto <mephystoonhell@gmail.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

pgsql-novice by date:

Previous
From: mephysto
Date:
Subject: Re: application_name
Next
From: Mephysto
Date:
Subject: Re: Show stored function code