copy tables/fields of postgreSQL database

Question

I'd like to create a new database with the same tables/fields as an existing database. I don't need any of the rows, I just need the schema. Is there a way to do this?

Try this: stackoverflow.com/questions/808735/…

The Blue Dog
– The Blue Dog

2013-12-20 23:11:46 +00:00
Commented Dec 20, 2013 at 23:11 — The Blue Dog
– The Blue Dog, Commented Dec 20, 2013 at 23:11

Joshua Moore · Accepted Answer · 2013-12-20 23:12:11Z

1

You can copy just the schema using pg_dump, then restore it in your new database.

pg_dump --schema-only

answered Dec 20, 2013 at 23:12

Joshua Moore

24.8k6 gold badges52 silver badges73 bronze badges

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

3 Comments

user1802143 Over a year ago

How would you create a new database with that schema?

Joshua Moore Over a year ago

@user1802143 Just use createdb to create a new database then pg_restore to restore the backup (which has only the schema) to that new database.

Joshua Moore Over a year ago

Provided both databases exist already you can do this in a single command. pg_dump oldDB --schema-only | psql -h localhost newDB;

Collectives™ on Stack Overflow

copy tables/fields of postgreSQL database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related