On Wed, Jan 6, 2010 at 1:02 PM, Hilda Raymond
<hildaraymond@gmail.com> wrote:
Hi,
Im new to postgres and and as soon as I listed databases using the psql -l command, i accidentally deleted the postgres default database. Im not sure what to do. Appreciate any help Thank you.
You can simply recreate the DB like so:
create database postgres;
It will take everything from the template1 database and make a copy by the name 'postgres'.
Best regards,
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.comsingh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet
Mail sent from my BlackLaptop device