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

From Peter Eisentraut
Subject Re: vacuum full for all databases
Date
Msg-id 200409020959.49744.peter_e@gmx.net
Whole thread Raw
In response to vacuum full for all databases  (Ilia Chipitsine <ilia@paramon.ru>)
List pgsql-general
Am Donnerstag, 2. September 2004 09:32 schrieb Ilia Chipitsine:
> 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" ?

You normally cannot access different databases from one database session.  But
you could use dblink from contrib to overcome this restriction.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Ilia Chipitsine
Date:
Subject: vacuum full for all databases
Next
From: Richard Huxton
Date:
Subject: Re: vacuum full for all databases