I've been working on this issue lately. There is quite a bit more to
a database than the tables (e.g., functions), and I'm not sure how you would go
about getting a backup of the entire database through SQL. I've been
working on a Java class to do the dump and restore. It doesn't look
terribly hard.
However, having said that, I wonder if someone could answer
something. How do pg_dump and pg_restore use stdout and stderr? I
saw a very old post that indicated -v caused all output to go to stderr. I
couldn't find anything recent and nothing in the manual.
Thanks!
Michael Schmidt
|