This seems to be more interesting for shell scripting:
psql -d DatabaseName -c 'select datname from pg_database where not
datistemplate' ;
datname
-----------------
fgm_eval
hotline
usj
dragon_devel
dragon_joujou
dragon_devel_v2
dragon_prod
fgm
(8 rows)
Cheers.
Najib.
----- Original Message -----
From: "Najib Abi Fadel" <[EMAIL PROTECTED]>
To: "Ilia Chipitsine" <[EMAIL PROTECTED]>
Cc: "generalpost" <[EMAIL PROTECTED]>
Sent: Thursday, September 16, 2004 12:08 PM
Subject: Re: [GENERAL] pg_dump in cycle
>
> Check out the "psql " command.
> U can use :
>
> psql -l
>
> which outputs sometinhg like
> List of databases
> Name | Owner | Encoding
> -----------------+-----------+-----------
> dragon_devel | ptufenkji | UNICODE
> dragon_devel_v2 | ptufenkji | UNICODE
> dragon_joujou | ptufenkji | UNICODE
> dragon_prod | ptufenkji | UNICODE
> fgm | gnakhle | UNICODE
> fgm_eval | ptufenkji | UNICODE
> hotline | postgres | UNICODE
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
> usj | ptufenkji | UNICODE
>
>
> for the shell script and do some text filtering in order to retrieve the
> databse names.
>
> (Or may be u can do a connection to the database from the shell script i
am
> not sure: i don't have a big experience in shell scripting)
>
>
>
>
>
> ----- Original Message -----
> From: "Ilia Chipitsine" <[EMAIL PROTECTED]>
> To: "Najib Abi Fadel" <[EMAIL PROTECTED]>
> Cc: "generalpost" <[EMAIL PROTECTED]>
> Sent: Thursday, September 16, 2004 11:01 AM
> Subject: 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 datname from pg_database;
> > >
> > > in order to get the list of databses
> > >
> > > HTH
> > >
> > > Najib.
> > >
> > > ----- Original Message -----
> > > From: "Ilia Chipitsine" <[EMAIL PROTECTED]>
> > > To: "Najib Abi Fadel" <[EMAIL PROTECTED]>
> > > 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" <[EMAIL PROTECTED]>
> > >>> To: <[EMAIL PROTECTED]>
> > >>> 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
> > >>>>
> > >>>
> > >>>
> > >>
> > >
> > >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
