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

Reply via email to