/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 vote261 views1 answer
Sauvegarde complète my sql
SQL
0 vote273 views1 answer
Run mysql xampp shell
SQL
3 votes221 views1 answer
How to get list of synonyms in oracle
SQL
0 vote267 views1 answer
Sql server query database space available
SQL
0 vote285 views1 answer
How to install postgresql on wsl
SQL
8 votes296 views1 answer
Oracle search stored procedures for text
SQL
0 vote269 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
2 votes293 views1 answer
Sql find not in list
SQL
10 votes284 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote321 views1 answer
Sql server query all database objects
SQL