Question: how to create a copy of database in postgresql?
Answer: CREATE DATABASE [Database to create] WITH TEMPLATE [Database to copy] OWNER [Your username];
CREATE DATABASE [Database to create] WITH TEMPLATE [Database to copy] OWNER [Your username];
SELECT pg_terminate_backend(pg_stat_activity.