Re: Show stored function code

Поиск
Список
Период
Сортировка
От Mephysto
Тема Re: Show stored function code
Дата
Msg-id CAG0sfBX9cT=YG2goi3c3nAZUus8Rc=p4DTqZM64nuc1e+ztGBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Show stored function code  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Show stored function code  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-novice
Oh, I'm sorry.

My function are written in sql and plpgsql.

Rergards.

Mephysto

On 28 March 2012 16:01, Merlin Moncure <mmoncure@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Show stored function code
Следующее
От: JORGE MALDONADO
Дата:
Сообщение: How to pg_dump v9.0 with v9.1