Re: Create Database using JDBC

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Nidhi Srivastava <nsrivastava(at)quark(dot)com>
Cc: Kris Jurka <books(at)ejurka(dot)com>, Thomas Dudziak <tomdzk(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org, John R Pierce <pierce(at)hogranch(dot)com>
Subject: Re: Create Database using JDBC
Date: 2005-12-17 13:23:19
Message-ID: 43A41147.5040602@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message j.random.programmer 2005-12-19 18:57:23 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy
Previous Message Markus Schaber 2005-12-17 13:21:32 Re: Create Database using JDBC