-- Making sure the database exists
SELECT * from pg_database where datname = 'my_database_name'
-- Disallow new connections
UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'my_database_name';
ALTER DATABASE my_database_name CONNECTION LIMIT 1;
-- Terminate existing connections
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'my_database_name';
-- Drop database
DROP DATABASE my_database_name
I tried using this, but I can't because DBeaver doesn't allow us to run that command. Is there a way to drop a database with DBeaver?
SQL Error [57P01]: FATAL: terminating connection due to administrator command
Error position:
Error position:
Error position:
Error position: