Re: rename database

Ok I think I got it. I just went ahead and updated the pg_database table and it works..


Nuwan Liyanage <alnuwan2@yahoo.com> wrote:

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.

---

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.