Skip site navigation (1) Skip section navigation (2)

Re: renaming a db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jik(at)foxinternet(dot)net
Cc: psql <pgsql-novice(at)postgresql(dot)org>
Subject: Re: renaming a db
Date: 2001-09-03 20:11:32
Message-ID: 6122.999547892@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
jik(at)foxinternet(dot)net writes:
> I have a feeling I can't do it, but is there a way to rename a dB?

In 7.1 or later I think it would work to just UPDATE the db's row in
pg_database.  But don't blame me if this fails to work ... make a
backup before you try it.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: jikDate: 2001-09-03 20:27:51
Subject: Re: renaming a db
Previous:From: Jochem van DietenDate: 2001-09-03 19:18:33
Subject: Re: Insert rule and seqences

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group