Обсуждение: 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
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