| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Ken Guest <kguest(at)stockbyte(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: rename |
| Date: | 2002-11-27 16:39:04 |
| Message-ID: | 1038415144.1806.46.camel@tokyo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2002-11-27 at 09:29, Ken Guest wrote:
> Guys,
> Is it possible to rename databases, and what's the syntax I should
> use?
Well, it's *possible* -- you can manually update the system catalogs,
like so:
UPDATE pg_database SET datname = 'newname' WHERE datname = 'oldname';
VACUUM FULL pg_database;
(The VACUUM is required as pg_database is not MVCC-aware).
However, this is not recommended operating procedure, if it destroys all
your data I won't take any responsibility :-) A safer route would be to
pg_dump the database and restore it with a different name.
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-27 16:40:00 | Re: Integrity constraint [false] problem |
| Previous Message | Jean-Christian Imbeault | 2002-11-27 16:35:52 | Re: Create Timestamp From Date and Time |