Re: [GENERAL] pg_dump in cycle

yes, but how can I integrate that query with shell script (which will perform actual dumping) ? I would even say, "select datname from pg_database where not datistemplate", becuase otherwise pg_dump will complain about template0 Cheers, Ilia Chipitsine U can use : select da

[GENERAL] pg_dump in cycle

Dear Sirs, I want to dump all databases, but separately each database in its own file, not all databases in one single file as pg_dumpall does. How can I implement that ? Cheers, Ilia Chipitsine ---(end of broadcast)--- TIP 4: Don't 'ki

Re: [GENERAL] vacuum full for all 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

[GENERAL] vacuum full for all databases

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;