| From: | Roland Walter <roland(dot)walter(dot)rwa(at)gmx(dot)net> |
|---|---|
| To: | Charlie Kelly <Charlie(at)CharlieKelly(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Use Driver to Create database? |
| Date: | 2006-11-19 21:42:07 |
| Message-ID: | 4560CFAF.7020105@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Charlie Kelly wrote:
> Is it possible to use the driver to create a new database (inside a java
> program),
> or is it necessary to first create the database using the createdb utility?
>
> If it is possible to use the driver, what is the correct syntax?
>
There is a SQL-command for that, look here:
http://www.postgresql.org/docs/8.1/interactive/sql-createdatabase.html
First connect to the postgres or template1 schema of the cluster, that
you created with initdb. Execute the "CREATE DATABASE". Reconnect to the
database you created.
Regards,
Roland.
- --
Dipl.-Phys. Roland Walter
mailto: roland (dot)walter (dot) rwa (at) gmx (dot) net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
iD8DBQFFYM+vxoOEAkary1ERAmASAJ0YfU9L9hepz68I0A2/yzV3ZjSAjwCeOnqU
LqefeHLpkkc2Np7cRYVmawY=
=4SOY
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roland Walter | 2006-11-19 21:46:37 | Re: Use Driver to Create database? |
| Previous Message | Heikki Linnakangas | 2006-11-19 20:31:31 | Re: ResultSet.getBytes() of bytea speedup batch |