Re: Use Driver to Create database? - Mailing list pgsql-jdbc

From John R Pierce
Subject Re: Use Driver to Create database?
Date
Msg-id 45613820.6080909@hogranch.com
Whole thread Raw
In response to Re: Use Driver to Create database?  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-jdbc
>> 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.
>
> You don't want to connect to template1, though, if the program is
> going to be used concurrently by more than one use. Template1 is used
> as template (hence the name) to make the new database, and it will
> throw an error if there's any other users connected to it beside the
> one issuing the CREATE DATABASE command.
>

indeed.  In fact you can connect to ANY existing database prior to
issusing the CREATE DATABASE command.  It is important, however, that
you be logged on with credentials that have the CREATEDB privilege



pgsql-jdbc by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Use Driver to Create database?
Next
From: Michael Paesold
Date:
Subject: Re: JDBC Support for standard_conforming_strings