On Thu, 2 Sep 2004, Richard Huxton wrote: > Ilia Chipitsine wrote: > > Dear Sirs > > > > I'm about to write plpgsql function which will "vacuum full" all existing > > databases. Below is an example how to get list of databases. > > > > What should I write instead of "raise notice" ? > > > raise notice ''datname = %'',list.datname; > > Something like: > EXECUTE ''VACUUM FULL '' || list.datname; > >
vacuumdb --all Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings