PGSQL删除正在使用的数据库

use postgres;

DROP DATABASE testdb;

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='testdb' AND pid<>pg_backend_pid();
 

三条语句一起上,不好意思上面的语句写反了

 

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='tids_submit_data_line' AND pid<>pg_backend_pid();

DROP DATABASE tids_submit_data_line;