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.