| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Joe L" <superist_joe(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: running a script from a command line |
| Date: | 2007-07-25 19:15:53 |
| Message-ID: | 162867790707251215n521c9037s25275d47f6d0568d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2007-07-25 21:13:24 | upgrade to 8.2.? or implement Slony, which first? |
| Previous Message | Joe L | 2007-07-25 18:52:22 | running a script from a command line |