* Najib Abi Fadel:
| 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_pro
ers.
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
>
> Ch
t; <[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
tname 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
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
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
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 po
