Postgres Pro
Downloads
Home   >   mailing lists

Re: Starting psql without a database connection - Mailing list pgsql-interfaces

From Oliver Elphick
Subject Re: Starting psql without a database connection
Date
Msg-id 1014650541.3217.6703.camel@linda
Whole thread Raw
In response to Starting psql without a database connection  (Michael Klatt <mdklatt@ou.edu>)
List pgsql-interfaces
Tree view 
On Sun, 2002-02-24 at 01:54, Michael Klatt wrote:
> Is there a way to start psql without connecting to a database?  Otherwise,
> what's the point of the 'CREATE DATABASE ...' command?

initdb creates the database template1, which is always there.  It serves
as the default template for all newly created databases.

So connect to template1 first and create your database from there.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
    "Peace I leave with you, my peace I give unto you; not      as the world giveth, give I unto you. Let not your
heartbe troubled, neither let it be afraid."                                        John 14:27

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] template Database
Next
From: "Dave Page"
Date:
Subject: Re: [GENERAL] template Database