X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C0DA1D1BA94 for ; Mon, 23 Feb 2004 03:29:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 34929-09 for ; Sun, 22 Feb 2004 23:29:11 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 0A72ED1BA90 for ; Sun, 22 Feb 2004 23:29:07 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1N3T8IO020410; Sun, 22 Feb 2004 22:29:08 -0500 (EST) To: "Sumita Biswas" Cc: pgsql-sql@postgresql.org Subject: Re: Postgres DB In-reply-to: <001101c3f9b8$54403aa0$2a154d0a@apac.cisco.com> References: <001101c3f9b8$54403aa0$2a154d0a@apac.cisco.com> Comments: In-reply-to "Sumita Biswas" message dated "Mon, 23 Feb 2004 08:24:17 +0530" Date: Sun, 22 Feb 2004 22:29:08 -0500 Message-ID: <20409.1077506948@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/335 X-Sequence-Number: 17025 "Sumita Biswas" 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