Chris Mair <list(at)1006(dot)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