Search Postgresql Archives

Re: Create a new database from JDBC?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dan Armbrust wrote:

How do I make a connection to a Postgresql database that (potentially) has 0 databases from jdbc, so that I can issue a create database command?

In that _other_ database, I can make a jdbc connection to an address like this:

jdbc:mysql://servername/

And then issue a "Create database foo" command.

Then I can reconnect to
jdbc:mysql://servername/foo

And everything is good.

If I try to connect to a postgresql database like this:

jdbc:postgresql://servername/

Postgres attempts to connect to a database that is named the same as the username I provided.

Certainly not what I want, since that database doesn't exist. Is there a system database I could always count on being available that I could connect to?

template1 but only if you allow it from pg_hba.conf.



Thanks,

Dan




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux