How to rename current database in pgadmin 4?

Question

I'm trying to rename a DB in pgAdmin 4. But I this get error: ERROR: current database cannot be renamed.

What's the process for renaming a database in pgAdmin (the docs are USELESS)? And google can't provide a solution.

Connect to a different database, then run `alter database .. rename to ...` https://www.postgresql.org/docs/current/static/sql-alterdatabase.html — , May 09 '18 at 07:10

score 8 · Answer 1 · answered Sep 26 '19 at 08:37

Using pgAdmin 4,

1) switch to the dashboard view

2) select the database to be renamed, right-click it and select Disconnect Database

3) Again select the database to be renamed, right-click it and select properties

4) change the name of the database in the Database field -click save

score 2 · Answer 2 · answered May 09 '18 at 07:14

2

right click on db name and Properties, then change the name and click Save:

Or just click on other db (eg postgres), open query tool and run

alter database "old" rename to "new";

answered May 09 '18 at 07:14

Vao Tsun

score 2 · Answer 3 · answered Jun 22 '20 at 13:17

2

You are probably trying to rename the database you are connected to. Switch to a different db and then execute the ALTER command.

answered Jun 22 '20 at 13:17

Pavan

3 Answers3