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;