Skip to content

Instantly share code, notes, and snippets.

@nhandl3

nhandl3/clone_db.sql

Last active September 5, 2015 04:17
Show Gist options
  • Save nhandl3/40d6da431d0e23c60761 to your computer and use it in GitHub Desktop.
Save nhandl3/40d6da431d0e23c60761 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL queries
Raw
clone_db.sql
-- http://stackoverflow.com/questions/876522/creating-a-copy-of-a-database-in-postgresql
CREATE DATABASE newdb WITH TEMPLATE currentdb OWNER dbuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment