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?
UPDATE!!
If I execute
select * from pg_database
I get the following result:
So database "President" does seem to exist. (Meanwhile I deleted someOtherDatabase and someOtherDatabase2.)
However, if I execute
drop database President
I get:
You can right click on the postgres
database and select edit connection
option. Under the PostgreSQL tab, check the Show all databases
option.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With