View Full Version : rename a DB
runhot
01-12-2010, 07:08 PM
how can i rename a database?
fozzy71
01-12-2010, 08:01 PM
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
01-13-2010, 04:50 AM
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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.