Re: view function on pg_toast

MN> March, 23 2005, 8:39:31:

b>> hello guys,

b>> I need help.  I have functions but it is saved to pg_toast, when I
b>> dump the database, the function from pg_toast is not copied. so is
b>> there any sql or syntax to view function data ?


MN> xxx:=\d pg-catalog.pg_proc
xxx:=\d pg_catalog.pg_proc

MN> xxx:=select procsrc from pg-catalog.pg_proc where proname=... and
MN> pronamespace=...;
xxx:=select procsrc from pg_catalog.pg_proc where proname=... and
pronamespace=...;





-- 
Regards,Mihail Nasedkin                         mailto:m.nasedkin.perm@mail.ru