Обсуждение: 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
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
Shape Yahoo! in your own image. Join our Network Research Panel today!
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