Re: running a script from a command line

Hello

>
> 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.
>

look http://www.postgresql.org/docs/8.2/interactive/libpq-pgpass.html

> 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.
>

http://www.postgresql.org/docs/8.2/interactive/sql-createtable.html
http://www.jdbc-tutorial.com/jdbc-create-table.html


Regards
Pavel Stehule