/SQL/Pgadmin postgres ERROR: database is being accessed by other users

Pgadmin postgres ERROR: database is being accessed by other users

PostgresVersion >=9.2

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

Similar codes

-1 vote145 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
20 votes167 views4 answers
How to find average in sql
SQL
11 votes130 views3 answers
Change column name sql server management studio
SQL
1 vote134 views1 answer
Mysql add fields
SQL
0 vote122 views1 answer
Like sql for second letter of the family name
SQL
0 vote132 views1 answer
Vbscript connect mssql
SQL
9 votes154 views1 answer
Alter table column change data type to text mysql
SQL
0 vote139 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote117 views1 answer
Sql beginning of previous month
SQL
8 votes123 views1 answer
Today minus 15 days postgresql
SQL