PostgreSQL - Rename database

ALTER DATABASE people RENAME TO customers;

c postgres

SELECT pg_terminate_backend( procpid )
FROM pg_stat_activity
WHERE procpid <> pg_backend_pid( )
    AND datname = 'name of database';

ALTER DATABASE 'name of database' RENAME TO 'new name of database';