Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DBeaver / PostgreSQL: "Error: database already exists", but I can't find it

I want to create database called "President" by rightclicking on PostgreSQL and selecting Create Database.

However, I get the error in the screenprint below.

I can create databases with other names like SomeOtherDatabase and SomeOtherDatabase2 (see screenprints).

Any ideas how I can find and delete the database "President" that seems to exist already?

enter image description here enter image description here

UPDATE!!

If I execute

select * from pg_database 

I get the following result:

enter image description here

So database "President" does seem to exist. (Meanwhile I deleted someOtherDatabase and someOtherDatabase2.)

However, if I execute

drop database President

I get:

enter image description here

like image 512
Frank Avatar asked Sep 13 '25 04:09

Frank


2 Answers

You can right click on the postgres database and select edit connection option. Under the PostgreSQL tab, check the Show all databases option.

like image 144
Oluwasegun Avatar answered Sep 15 '25 17:09

Oluwasegun


2025 Update

  1. Right-click on your connection
  2. Click "Edit connection"
  3. Left panel, click "Connection settings"
  4. Select PostgreSQL tab Check the box "Show all databases"

enter image description here

enter image description here

like image 24
Omer Avatar answered Sep 15 '25 17:09

Omer