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.