supawaza
1/10/2018 - 3:46 PM

Postgres - Clone a DB

Quickly clone an existing postgres db. Needs to be in psql #postgres #commandline

command
content_copyfile_download
CREATE DATABASE <new_db_name> WITH TEMPLATE <original_db OWNER <user>;