On 11/6/06, CSN <[EMAIL PROTECTED]> wrote:
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 -> template0.sql
template1 -> template1.sql
db1 -> db1.sql
db2 -> db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall, or does
pg_dumpall dump
additional things (if so, please describe how they'd also be dumped)?
there are many ways to do this, but this would be a fun exercise for pl/sh.
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq