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: http://stackoverflow.com/questions/808735/postgresql-how-to-create-a-copy-of-a-database-or-schema — The Blue Dog, Dec 20 '13 at 23:11

score 1 · Answer 1 · answered Dec 20 '13 at 23:12

1

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

pg_dump --schema-only

answered Dec 20 '13 at 23:12

Joshua Moore

24,706
6
50
73

How would you create a new database with that schema? – user1802143 Dec 20 '13 at 23:27
@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 Dec 20 '13 at 23:30
Provided both databases exist already you can do this in a single command. pg_dump oldDB --schema-only | psql -h localhost newDB; – Joshua Moore Dec 20 '13 at 23:32

copy tables/fields of postgreSQL database

1 Answers1