Re: How to set default database - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to set default database
Date
Msg-id 4B6B192D.2000305@gmail.com
Whole thread Raw
In response to How to set default database  (Krzysztof Walkiewicz <bars0@op.pl>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Need Advice In Improving Database Disc Usage
Next
From: Scott Mead
Date:
Subject: Re: How to set default database