Re: Create Database using JDBC - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Create Database using JDBC
Date
Msg-id 43A41147.5040602@logix-tt.com
Whole thread Raw
In response to Re: Create Database using JDBC  ("Nidhi Srivastava" <nsrivastava@quark.com>)
List pgsql-jdbc
Hi, Nidhi,

Nidhi Srivastava schrieb:
> But even that alternate template database would need to be created the
> first time after server installation by connceting to the template1 DB??
> Right??

No, you can specify any database that has no active connections (exept
possibly your own single one) as template on database creation,
including template0 (which is usually set up to refuse connections).

So connect to template1, and create your new template database with
using template0 as template.

HTH,
Markus

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Create Database using JDBC
Next
From: "j.random.programmer"
Date:
Subject: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy