Quick Links

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

Re: Postgres DB at 2004-02-23 02:54:17 from Sumita Biswas

Responses

Re: Error Number in Function at 2004-02-23 03:33:41 from Sumita Biswas
Input Arguments at 2004-02-23 06:21:16 from Sumita Biswas
DATEADD at 2004-02-23 08:17:22 from Sumita Biswas
EXECUTing QUERY: at 2004-02-23 08:33:05 from Sumita Biswas
Re: Postgres DB at 2004-02-23 08:54:32 from Sumita Biswas
CURSORS - Please help urgent. at 2004-02-24 11:51:16 from Sumita Biswas (sbiswas)
Execute Query in Postgres Function at 2004-02-24 15:35:07 from Sumita Biswas (sbiswas)
Unicode Support at 2004-02-26 05:51:12 from Sumita Biswas (sbiswas)
Postgres DB at 2004-04-23 18:10:41 from Sumita Biswas

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