From: | harrold(at)sage(dot)che(dot)pitt(dot)edu |
---|---|
To: | jik(at)foxinternet(dot)net |
Cc: | psql <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: renaming a db |
Date: | 2001-08-31 23:12:52 |
Message-ID: | Pine.LNX.4.21.0108311912110.10479-100000@sage.che.pitt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)foxinternet(dot)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(at)postgresql(dot)org)
|
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Tessier and Martine Veilleux | 2001-09-01 20:12:45 | SunOS 5.7 install |
Previous Message | jik | 2001-08-31 20:03:58 | renaming a db |