update pg_database set datname=<new_name> where datname=<old_name>;
------------------( Forwarded letter 1 follows )---------------------
Date: Mon, 25 Oct 2004 08:59:03 -0400
Subject: [ADMIN] db rename
I thought there was an option to rename a database? I cannot seem to
find the syntax in any of my books or on the web site. Am I incorrect?
We are running 7.3.4. We have to bring our sytem down to upgrade the
release this afternoon. There are a number of db changes taking place so
I was thinking instead of taking the system down for an extended amount
of time I could build another database with all our new items and then
just rename it when we are ready.
Is there a rename option out there for our version?
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
Description: application/octet-stream (1.8 KB)
pgsql-admin by date
|Next:||From: Tsirkin Evgeny||Date: 2004-10-25 13:42:02|
|Subject: Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg|
|Previous:||From: Rajesh Kumar Mallah||Date: 2004-10-25 13:12:21|
|Subject: Re: db rename|