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 ?
CREATE OR REPLACE FUNCTION vacuum_all() RETURNS integer
AS '
DECLARE
query text;
list RECORD;
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
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
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:
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 =