Incremental Development

On Tue, 13 Jan 2004, Phil Campaigne wrote:

I am developing a java/postgresql application using ant and junit. I
want to deploy tested builds along with matching tables in
postgresqlwith test data in them.

What is the best way to deploy versions of the tables with test data to
postgresql to match a war file for each new build of the application?
thanks,
Phil

the best way I've found is to just use a pg_dump file of the database (I
usually put individual apps in their own database / schema for easy backup
and restore and such.)

If you can't run psql by shelling out, you can just execute each line of
the sql dump one at a time, inside a transaction block.