Re: pg_dump in cycle

U can use :
select datname from pg_database;

in order to get the list of databses

HTH

Najib.

----- Original Message -----
From: "Ilia Chipitsine" <ilia(at)paramon(dot)ru>
To: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
Sent: Thursday, September 16, 2004 10:41 AM
Subject: Re: [GENERAL] pg_dump in cycle

> > Use pg_dump instead of pg_dumpall
> >
> > example:
> > pg_dump databaseName > databaseDumpFile
> >
> > if u have many databases, you can make a script that dumps each database
in
>
> sure, I have many databases.
> how can I write such script without explicitly specifying database names ?
> I do not want to modify that script after I have added database.
>
> > it's own file ....
> >
> >
> >
> > ----- Original Message -----
> > From: "Ilia Chipitsine" <ilia(at)paramon(dot)ru>
> > To: <pgsql-general(at)postgresql(dot)org>
> > Sent: Thursday, September 16, 2004 8:08 AM
> > Subject: [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 'kill -9' the postmaster
> >>
> >
> >
>