rename a DB

[runhot]

how can i rename a database?

[fozzy71]

I have done it once or twice, and the renamed DB seemed to work fine.

I recommend you backup and export your DB to text files before you do this, in case you have problems after renaming it.

start > programs > postgresql > pgadmin > connect to the server > right-click the DB and choose Properties, then edit the Name.

http://i207.photobucket.com/albums/bb176/fozzy71/Misc%20Crap/1x1-transparent.png

[netsrak]

There is a SQL statement for doing this. "Alter database.." or sth. like that but you should be familiar with SQL and Postgres to do this so Fozzies way is the easiest.