Well you might want to make sure the servlet only does one pg_dump at a
time to a particular file in a secured directory (making sure you don't
have any funny symlink problems) and all that sort of boring security,
reliability and predictability stuff. Don't forget the UI. The dump could
take a while.
At 11:27 AM 6/7/2004 -0400, Campano, Troy wrote:
>Easiest thing to do is to call pgsql from your servlet, have it dump the
>file somewhere in your web apps directory, and then either send the link
>to that file to the client or automatically forward the client there.
>
>Option 2 would be to use JDBC to view the meta data of the table and use
>it to write "CREATE" statements, and then build inserts from this data,
>but this would be very time consuming and difficult to do.
