Thread: view function on pg_toast

view function on pg_toast

From
bandeng
Date:
hello guys,

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

Thanks

Ricky


Re: view function on pg_toast

From
Michael Fuhr
Date:
On Wed, Mar 23, 2005 at 11:39:31AM +0800, bandeng wrote:

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

What exactly do you mean by "it is saved to pg_toast" and how do
you know that?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


Re: view function on pg_toast

From
Mihail Nasedkin
Date:
Hello, bandeng.

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 ?


xxx:=\d pg-catalog.pg_proc

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


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



Re: view function on pg_toast

From
Mihail Nasedkin
Date:
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



Re: view function on pg_toast

From
bandeng
Date:
to Michael,

We use pg manager from EMS and misstype. it should be created on
public but on pg_toast


On Wed, 23 Mar 2005 10:09:19 +0500, Mihail Nasedkin
<m.nasedkin.perm@mail.ru> wrote:
> 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
> 
> 


-- 
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................