/SQL/Postgres duplicate database in same server while other session is using source database

Postgres duplicate database in same server while other session is using source database

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '[Database to copy]'
AND pid <> pg_backend_pid();
CREATE DATABASE [Database to create]
WITH TEMPLATE [Database to copy]
OWNER [Your username];

Source: dataschool.com

Similar codes

0 vote128 views1 answer
Sql compound operators
SQL
-1 vote84 views1 answer
How to create script to connect to oracle database and run query
SQL
3 votes153 views1 answer
Oracle function return
SQL
6 votes215 views1 answer
Sql insert values into table
SQL
0 vote128 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote138 views2 answers
Oracle chain rules
SQL
4 votes132 views1 answer
Change nls_date_format
SQL
2 votes143 views1 answer
How to get non distinct values in sql
SQL
0 vote134 views1 answer
Difference between 2 query results sql server
SQL
0 vote151 views1 answer
Sql server phone constraint
SQL