running a script from a command line

Hi,

I want to use postgres as part of my application. I need to create a database and initialize it and fill it with data as part of the installation process. There is information that is expected to be there.

Now when I try to use psql from a batch script it always prompts for a password. I would like for the installation process to not require any interaction.

Is there a way to create a database and add tables to it that doesn't require the password prompt? I didn't see a command line parameter that allowed you to just enter a password in the command line.

The application is in Java, so I was thinking about using JDBC to create the database and then to create the tables. Is it possible to create a database/tables with JDBC? I'm not too familiar with it, I've been using Hibernate for the database transactions.

The best option is using the script, as I already have one that works.

Thanks,
Joe

____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow