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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > -- Gutten Aben Sugeng Sonten, Jangane Kurang Santen bandeng.................... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
