Deleting a database in Postgres with DBeaver

Viewed 15
-- 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:
0 Answers
Related