rename database

From: Nuwan Liyanage <alnuwan2(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: rename database
Date: 2008-02-06 19:42:26
Message-ID: 952808.93056.qm@web46005.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I am trying to rename my database; I used the following command,
Alter database postgres rename to post_dev;
but I get a error saying that the "current database may not be renamed"
I look at the documentation, and it says that I need to connect to a different database in order do that?
can someone please help me how to do that..
Thanks
alnuwan


---------------------------------
Never miss a thing. Make Yahoo your homepage.

Browse pgsql-admin by date

  From Date Subject
Next Message Nuwan Liyanage 2008-02-06 20:35:41 Re: rename database
Previous Message Chris Hoover 2008-02-06 17:44:34 Help calculating load values