Create a copy of a PostgreSQL database

Creates a new Postgres database, using an existing database as a template for which to build the database.

Authored by: zbyszek

Brought to you by Warp, a free terminal reimagined to work like a modern app.

owner_name

original_db

new_db

Command

createdb -O owner_name -T original_db new_db

Tags