On 11/6/06, CSN <cool_screen_name90001@xxxxxxxxx> 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