Sql

Search

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()

Comment

PREVIOUS	NEXT

Code Example
Sql :: what data type to use for phone number in sql
Sql :: sql where is not number
Sql :: convert negative to positive in sql
Sql :: pl sql create function
Sql :: missing left parenthesis error in sql
Sql :: sql order of operations
Sql :: sql highest salary by location
Sql :: if sql
Sql :: demmarrer un service mysql teminal cmd
Sql :: Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
Sql :: mysql custom sort order
Sql :: create postgres role and database for bitbucket
Sql :: copy data from one postgres container to another
Sql :: postgresql isnull with max
Sql :: desinstaller mysql sur ubuntu definitivement
Sql :: execution order in sql
Sql :: mssql now diff 90 day
Sql :: SQL SUM() Function
Sql :: convert all tables in database to from myisam to innodb
Sql :: sql alternative to max statement
Sql :: max mysql
Sql :: FIND ABOVE AVERAGE SALARY EARNER IN SQL
Sql :: window function sql
Sql :: sql constraint to check date less than current date
Sql :: T-SQL and the WHERE LIKE %Parameter% clause
Sql :: sql like with multiple values
Sql :: sql server get week dates from week number
Sql :: what is table in sql
Sql :: sql ignore
Sql :: how to output a different column name in mysql

Search

SQL

pgadmin postgres ERROR: database is being accessed by other users

ADD CONTENT