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.