Re: [SQL] view function on pg_toast

2005-03-23 Thread bandeng
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_toa

Re: [SQL] view function on pg_toast

2005-03-22 Thread Mihail Nasedkin
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_pro

Re: [SQL] view function on pg_toast

2005-03-22 Thread Mihail Nasedkin
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

Re: [SQL] view function on pg_toast

2005-03-22 Thread Michael Fuhr
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

[SQL] view function on pg_toast

2005-03-22 Thread bandeng
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 ---(end of broadcast)--- TIP 9: the plan