Postgres killing connections on db

SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'database_name'
    ;

Source: stackoverflow.com

Similar codes

-3 votes208 views1 answer
Remove spaces sql 2008
SQL
1 vote214 views1 answer
Count of tables in database mysql
SQL
0 vote207 views1 answer
Oracle right characters
SQL
0 vote204 views1 answer
Oracle list dblink
SQL
5 votes201 views2 answers
Mysql where in array
SQL
2 votes223 views1 answer
Scaffold npgsql net core
SQL
0 vote207 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote216 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote212 views1 answer
How to query all tables mysql at the same time
SQL
5 votes218 views3 answers
Select tables from mysql database
SQL