Thread: Starting psql without a database connection

Starting psql without a database connection

From
Michael Klatt
Date:
Is there a way to start psql without connecting to a database?  Otherwise,
what's the point of the 'CREATE DATABASE ...' command?

Michael Klatt



Re: Starting psql without a database connection

From
"Arguile"
Date:
Michael Klatt wrote:
> Is there a way to start psql without connecting to a database?

No. psql is a client to the server.

> Otherwise, what's the point of the 'CREATE DATABASE ...' command?

I'll turn that around. What's the point of issuing a CREATE DATABASE command
when you aren't connected to a server to create it on?

You might want to read:

http://www.postgresql.org/idocs/index.php?managing-databases.html




Re: Starting psql without a database connection

From
Oliver Elphick
Date:
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