Postgre常用SQL

查询当前连接信息

SELECT pid, usename, application_name, client_addr, query, state
FROM pg_stat_activity
WHERE datname = 'mynewdatabase';

删除除当前连接之外的其它连接

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