Re: view function on pg_toast

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(dot)nasedkin(dot)perm(at)mail(dot)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(dot)nasedkin(dot)perm(at)mail(dot)ru
>
>

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