Ok I think I got it. I just went ahead and updated the pg_database table and it
works..
Nuwan Liyanage <[EMAIL PROTECTED]> 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.
