drop-db-connections-opened.sql: Delete Postgres Database with connections opened

drop-db-connections-opened.sql

-- Delete Database with connections opened

-- Postgres older than 13 don't support FORCE option, in this case pg_terminate_backend() is used:

SELECT pid, pg_terminate_backend(pid)
  FROM pg_stat_activity
  WHERE pg_stat_activity.datname = 'dbname';

DROP DATABASE dbname;

-- Postgres +13:

DROP DATABASE IF EXISTS dbname WITH (FORCE);

CREATE DATABASE dbname;