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(at)yahoo(dot)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.