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.