I have read that template1 is the default DB that gets installed with
But when I type the command "psql" and don't specify a DB name, it says
psql: FATAL: Database "postgres" does not exist in the system catalog.
This is the reason why I guessed that it expects the postgres DB be
installed by default.
Also earlier I have seen this DB get installed by itself, although we
have not created it.
Any answers to the above questions.
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, February 21, 2004 9:41 PM
To: Sumita Biswas
Subject: Re: [SQL] Function
"Sumita Biswas" <sbiswas(at)cisco(dot)com> writes:
> We installed postgres, but it did not install the default DB
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
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2004-02-23 03:29:08|
|Subject: Re: Postgres DB |
|Previous:||From: Greg Patnude||Date: 2004-02-23 00:45:51|
|Subject: Re: User defined types -- Social Security number...|