How can we check if there is another database with the same name of our database in pgAdmin4?

Question

For creating new database, in pgAdmin4 how can write the SQL code to check there is another Database that the name is same to our database or not?

CREATE DATABASE sportner
with
OWNER =  POSTGRES           
ENCODING = 'UTF8'       
TABLESPACE = pg_default
CONNECTION LIMIT = -1;

Answer 1

1. understand that a PostgreSQL instance has many databases, and a database has many schemas. This is different from MySQL, for which an instance has many schemas (which are called "databases")

2. understand that PostgreSQL's databases are segregated from each other - on purpose, and for good reason. You need a foreign data wrapper for cross-database communications

There are a couple ways to list the databases in a PG cluster:

1. using psql (CLI): use the \list command
2. using SQL: SELECT datname FROM pg_database WHERE datistemplate = false;

This answer tells you how to create a database conditionally

Answer 2

DROP DATABASE IF EXISTS SPORTNER;
CREATE DATABASE sportner
with
OWNER =  POSTGRES
ENCODING = 'UTF8'       
TABLESPACE = pg_default`enter code here`
CONNECTION LIMIT = -1;