/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 vote125 views1 answer
Sql gather statistics to increase performance
SQL
2 votes112 views1 answer
Get first 2 letter in sql
SQL
4 votes124 views1 answer
Mysql query first character
SQL
0 vote122 views1 answer
Monthly Birthday SQL Query
SQL
0 vote119 views3 answers
How to increase size of column in sql
SQL
7 votes114 views6 answers
Reset identity column in sql server
SQL
27 votes120 views3 answers
Mysql show tables in database
SQL
0 vote115 views2 answers
Sql query for getting details by id
SQL
8 votes135 views2 answers
Update sql server from another table
SQL
4 votes115 views2 answers
Oracle default date format
SQL