/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

5 votes197 views3 answers
Show indexes mysql
SQL
0 vote166 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes173 views1 answer
Mysql last 7 days including today
SQL
7 votes176 views1 answer
Oracle pagination query offset
SQL
10 votes175 views1 answer
Oracle object dependencies
SQL
5 votes195 views2 answers
Get columns number sql
SQL
7 votes142 views1 answer
Alter table add key sql
SQL
1 vote237 views1 answer
Sql oracle update multiple rows
SQL
0 vote180 views1 answer
Sql remove first character from string
SQL
0 vote161 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL