/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 vote307 views1 answer
How to remove default in mysql
SQL
0 vote342 views1 answer
Sql convert unix time to date
SQL
2 votes349 views1 answer
Q operator in plsql
SQL
1 vote365 views1 answer
Oracle create program if not exists
SQL
2 votes353 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote362 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote333 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
10 votes336 views1 answer
Oracle dependencies table
SQL
50 votes402 views6 answers
Install mysql on ubuntu
SQL
3 votes329 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL