Re: template0 1 psql -d .. (newbie) - Mailing list pgsql-general

From Tom Lane
Subject Re: template0 1 psql -d .. (newbie)
Date
Msg-id 16787.1038523160@sss.pgh.pa.us
Whole thread Raw
In response to template0 1 psql -d .. (newbie)  (Loeke <LoekeDoeLoekeDoe@hotmail.com>)
List pgsql-general
Loeke <LoekeDoeLoekeDoe@hotmail.com> writes:
> why does template0 not work?

It's not supposed to.

> is this the only way to use psql : psql -d templateXX
> or can you also get something working like: psql -d mydb

You need to create some databases in your installation.  You may care to
read a little in the Administrator's Guide, eg
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html
which in particular explains what template0 is for and why the system
won't let you into it.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create Timestamp From Date and Time
Next
From: Oliver Elphick
Date:
Subject: Re: Trigger once again