How to set default database

From: Krzysztof Walkiewicz <bars0(at)op(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to set default database
Date: 2010-02-04 18:37:30
Message-ID: 4B6B13EA.4070004@op.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello!

I created database "krzysztof" for practice postgresql. After few days i
deleted that database and i created the next one "cwiczebna". Now when
I type "psql" i get strange info, something like: "CRITICAL: base
"krzysztof" don't exist". Now i need to type "psql cwiczebna" to log in
to new database. How to set the default database or connect
automatically to "cwiczebna" database when I type "psql" in terminal. I
am using Debian Lenny distro.

--
Krzysztof Walkiewicz
-----------------------
bars0(at)op(dot)pl

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Hilda Raymond 2010-02-04 19:01:28 Any way to recover a lost db..
Previous Message Mohlomi Moloi 2010-02-04 06:45:17 Re: Postgres Trainign in RSA