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

user_2447656 0
Viewed 8538

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

dbeaver create-table postgresql sql database
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.

user_164215550

You can query catalog view pg_database to check if the database already exists:

select datname from pg_database WHERE datname = 'president'

And drop it with drop database:

drop database president;

Note that Postgres' drop database syntax supports the if exists clause, which may come handy in your use case:

drop database if exists president;
user_106767160
Related