/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

0 vote312 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote368 views1 answer
Gcloud sql instance list
SQL
103 votes562 views1 answer
Like sql
SQL
0 vote331 views1 answer
How to convert DateTime to VarChar SQL
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote329 views1 answer
Mysql concat and use as where column
SQL
2 votes327 views1 answer
Oracle index size
SQL
2 votes329 views1 answer
Oracle number to percentage
SQL
5 votes355 views2 answers
Oracle find all tables with column name
SQL
0 vote362 views1 answer
Count columns psql(PostreSQL)
SQL