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

From Scott Mead
Subject Re: How to set default database
Date
Msg-id d3ab2ec81002041103u41acd6c4ud2c2f52610264b4f@mail.gmail.com
Whole thread Raw
In response to How to set default database  (Krzysztof Walkiewicz <bars0@op.pl>)
List pgsql-general

On Thu, Feb 4, 2010 at 1:40 PM, Krzysztof Walkiewicz <bars0@op.pl> 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.

Setup the 'PGDATABASE' environment variable


--Scott


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to set default database
Next
From: Merlin Moncure
Date:
Subject: Re: Verify a record has a column in a plpgsql trigger