Thread: How to set default database

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@op.pl

On 02/04/2010 10:40 AM, Krzysztof Walkiewicz wrote:
> 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.

By default if you do not specify a database psql does -d
'your_username'. If you do not have a database with that name you will
need to specify the database you want to connect to explicitly.

--
Adrian Klaver
adrian.klaver@gmail.com