Clone database and it's tables structure to another database (without data)

Question

I have already known query to clone like:

CREATE DATABASE db_dest WITH TEMPLATE db_src OWNER postgres

But that query also cloned the data in the tables. I want to clone all tables and it's structures in the database, but not the data. How can I do this?

There is an answer here: stackoverflow.com/questions/808735/…, using pg_dump with the --schema-only option. — vitaly-t
– vitaly-t, Commented May 23, 2018 at 8:05
@Giovanno: no, the way through a SQL dump without data is the best option you have. Alternatively clone the database, then truncate all tables. — user330315
– user330315, Commented May 24, 2018 at 6:33

Pavel B. · Accepted Answer · 2018-05-23 08:14:38Z

1

I'm not sure if is SQL comand for this. but you can try

create backoup in PGadmin and in dump option select only schema option and then restore it to new db.

answered May 23, 2018 at 8:14

Pavel B.

9051 gold badge7 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Clone database and it's tables structure to another database (without data)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related