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