syntax is:
update pg_database set datname=<new_name> where datname=<old_name>;
checkpoint;
HTH,
Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Mon, 25 Oct 2004 08:59:03 -0400
To: Postgres.Admin.List[pgsql-admin]@postgresql.org.comp
From: Jodi.Kanter[jkanter]@virginia.edu.comp
Sender: pgsql-admin-owner+m15321@postgresql.org.comp
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?
thanks
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu <mailto:jkanter@virginia.edu100>