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

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