Postgres Pro
Downloads
Home   >   mailing lists

Re: db rename - Mailing list pgsql-admin

From Tom Lane
Subject Re: db rename
Date
Msg-id 18281.1098713886@sss.pgh.pa.us
Whole thread Raw
In response to db rename  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Tree view 
Jodi Kanter <jkanter@virginia.edu> writes:
> I thought there was an option to rename a database?

No, but you could always do an UPDATE on pg_database.  It might be a
good idea to ensure there are no backends running in the target database
when you do the update.  (I think that recent releases wouldn't care
particularly, but I'm less sure about 7.3.4.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Tsirkin Evgeny
Date:
Subject: Re: ' in transaction' problem in mod_perl/DBI/DBD-Pg
Next
From: "Rigmor Ukuhe"
Date:
Subject: Index relation size