Re: Postgres DB

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sumita Biswas" <sbiswas(at)cisco(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Postgres DB
Date: 2004-02-23 03:29:08
Message-ID: 20409.1077506948@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Sumita Biswas" <sbiswas(at)cisco(dot)com> writes:
> But when I type the command "psql" and don't specify a DB name, it says
> that:
> psql: FATAL: Database "postgres" does not exist in the system catalog.

Yes, because psql's default behavior is to try to connect to the DB with
the same name as your user name. That doesn't mean that such a DB is
guaranteed to exist, or even that anything is going to try to create it
for you. It's just a default behavior that people have found handy.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sumita Biswas 2004-02-23 03:33:41 Re: Error Number in Function
Previous Message Sumita Biswas 2004-02-23 02:54:17 Re: Postgres DB