How to copy (or create new one and copy) a PostgreSQL database to another (new) database? Is there any query based method for doing this?
Join the Stack Overflow Community
Stack Overflow is a community of 6.5 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
Join them; it only takes a minute:
|
|
|
Try This: CREATE DATABASE newdb WITH TEMPLATE olddb; |
|||||||||
|
