pg dump - How do I do a schema only backup and restore in PostgreSQL?

Question

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any single command available for this? For example, can I pg_dump and restore in single line?

question from:https://stackoverflow.com/questions/12564777/how-do-i-do-a-schema-only-backup-and-restore-in-postgresql

Answer 1

pg_dump --schema=masters oldDB > masters1.sql
cat masters1.sql | psql newDB

or

in single command you can do by this

pg_dump oldDB --schema masters  | psql -h localhost newDB;