pg_proc.prosrc -> can I see the function's source?

Поиск
Список
Период
Сортировка
Искать

pg_proc.prosrc -> can I see the function's source?

От:
Raphael Bauduin <raphael@be.easynet.net>
Дата:
Hi all,

When I look at the entry of a pg_prc_row, I get the prosrc column. Does
that represent the id of the source of this function? Can I retrieve it
somewhere and take a look at it without pgdump -s (didn't try it yet,
but read in the archives that this would be a solution)?

Example:

select proname,prosrc  from pg_proc where proname='RI_FKey_noaction_del';
       proname        |        prosrc        
----------------------+----------------------
 RI_FKey_noaction_del | RI_FKey_noaction_del
(1 row)


Thanks for your help!

Raph

Re: pg_proc.prosrc -> can I see the function's source?

От:
"Victor Yegorov" <viktors.jegorovs@nordlb.lv>
Дата:
* Raphael Bauduin  [15.05.2003 15:14]:
> Hi all,
> 

I'm using:

=> \df+ function_name

-- 

Victor Yegorov

Re: pg_proc.prosrc -> can I see the function's source?

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:

On Thu, 15 May 2003, Raphael Bauduin wrote:

> When I look at the entry of a pg_prc_row, I get the prosrc column. Does
> that represent the id of the source of this function? Can I retrieve it
> somewhere and take a look at it without pgdump -s (didn't try it yet,
> but read in the archives that this would be a solution)?

The below is a function in C, so you won't get it even with a pgdump -s
(it's one of the foreign key triggers defined in
src/backend/utils/adt/ri_triggers.c if I remember location correctly)

>        proname        |        prosrc
> ----------------------+----------------------
>  RI_FKey_noaction_del | RI_FKey_noaction_del

FAQ