Skip site navigation (1) Skip section navigation (2)

Re: Show stored function code

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: mephysto <mephystoonhell(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Show stored function code
Date: 2012-03-28 14:01:34
Message-ID: CAHyXU0yaT6wS2ce=njHKXnBaabYpst=YX4dk2bMmG8UJMYUDRw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: MephystoDate: 2012-03-28 14:05:01
Subject: Re: Show stored function code
Previous:From: mephystoDate: 2012-03-28 13:36:43
Subject: Re: application_name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group