/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 vote306 views1 answer
Date 3 months from today sql
SQL
0 vote276 views1 answer
Mysql min value row
SQL
3 votes288 views1 answer
Get current month last date in sql server
SQL
0 vote279 views1 answer
Sqlalchemy get schema from database
SQL
0 vote298 views1 answer
Mysql command line top 10
SQL
0 vote252 views1 answer
How to count null values in sql
SQL
1 vote283 views1 answer
Round function in sql oracle
SQL
1 vote260 views1 answer
Scaffold mysql database
SQL
0 vote257 views1 answer
Sqlite referential integrity
SQL
0 vote273 views1 answer
Mysql count grouped rows
SQL