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 241F7D1D1A4 for ; Sat, 21 Feb 2004 16:11:08 +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 80737-01 for ; Sat, 21 Feb 2004 12:11:06 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B669ED1D14B for ; Sat, 21 Feb 2004 12:11:05 -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 i1LGAtpR011976; Sat, 21 Feb 2004 11:10:56 -0500 (EST) To: "Sumita Biswas" Cc: pgsql-sql@postgresql.org Subject: Re: Function In-reply-to: <007001c3f77c$451b5390$2a154d0a@apac.cisco.com> References: <007001c3f77c$451b5390$2a154d0a@apac.cisco.com> Comments: In-reply-to "Sumita Biswas" message dated "Fri, 20 Feb 2004 12:09:18 +0530" Date: Sat, 21 Feb 2004 11:10:55 -0500 Message-ID: <11975.1077379855@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/330 X-Sequence-Number: 17020 "Sumita Biswas" writes: > We installed postgres, but it did not install the default DB "postgres". The only DB that exists in a fresh installation is "template1". If you want to create a DB named "postgres", use the createdb script. BTW, it's bad manners to ask a new question by following up an existing unrelated thread. Start a new thread with an appropriate subject line. Otherwise you're wasting the time of the other people on the mailing list, who are exactly the people who might answer your question. regards, tom lane