How to rename postgresql database?

Question

PostgreSQL

Hello!
Can you please tell me how to rename the postgresql database? Tried in pgadmin - must be owner of database. Did through the console ALTER DATABASE name RENAME TO newname nothing happened.

Answer 1

You are doing something wrong.

postgres=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 test      | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 


postgres=# alter database test rename to test1;
ALTER DATABASE
postgres=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 test1     | postgres | UTF8     | en_US.utf8 | en_US.utf8 |

Answer 2

";" must be placed at the end of the request