Re: renaming a db

just dump the databse, create a new one and insert the info back into a
new one. you might even be able to string the commands together with
pipes.

--
john
There is no operating system but linux and linus is its kernel maintainer.

Sometime in August jik@foxinternet.net assaulted keyboard and produced...

|I have a feeling I can't do it, but is there a way to rename a dB?
|
|I am doing major scheme alterations and recreating the DB from the data
|origionally used as well as some data from the origional DB....I would
|like to be able to just plug it in without having to alter the dbname in
|all of the scripts that use it....I know I can dump the db, drop them
|both and recreate...but renaming would be easier :P
|
|---------------------------(end of broadcast)---------------------------
|TIP 2: you can get off all lists at once with the unregister command
|    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
|