Re: vacuum full for all databases - Mailing list pgsql-general

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;

--
   Richard Huxton
   Archonet Ltd