How can I create a PostgreSQL database in Java?

Question

I have created a set of SQL queries that modify a database, and now I want to test them.

How can I create a local and temporary PostgreSQL database to test my queries. I'm working in Java.

Answer 1

You CAN create and drop PostgreSQL db's via Java using the Statement object.

Example:

Connection c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/", "username", "password");
Statement statement = c.createStatement();
statement.executeUpdate("DROP DATABASE mydb");

See the following link for a good starting point:

http://www.jvmhost.com/articles/create-drop-databases-dynamically-java-jsp-code