Re: Change the name of the database - Mailing list pgsql-novice

Chris Mair <list@1006.org> writes:
>> I'm trying to change the name of my psql database.
>> Does it exist any command to do this.

> just issue this command:
>   alter database old_db_name rename to new_db_name;

Note that this command exists only since PG 7.4.  In earlier releases,
you can fake it by executing a manual UPDATE on pg_database.  (Beware
that you need to do a CHECKPOINT afterware to be sure that newly
connecting backends will see the updated name.)

            regards, tom lane