Re: template0 1 psql -d .. (newbie)

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