Thread: Changing Database Name

Changing Database Name

From
James Kelty
Date:

Hello,

Through a slight SNAFU, a new database was loaded (takes about 30 hours)
with an incorrect name. I would like to change the name of the database,
NOT the tables. How can I do this? Can someone point me to
documentation? I haven't found any yet.

Thanks!

-James



Re: Changing Database Name

From
Manuel Sugawara
Date:
James Kelty <jamesk@ashlandagency.com> writes:

> Hello,
>
> Through a slight SNAFU, a new database was loaded (takes about 30 hours)
> with an incorrect name. I would like to change the name of the database,
> NOT the tables. How can I do this? Can someone point me to
> documentation? I haven't found any yet.

Not sure about side effects, but you can connect to the template1 data
base and execute something like

update pg_database set datname = 'newName' where datname = 'oldName';

HTH,
Manuel.