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

postgresql pg-dump
user1671630 picture user1671630 · Sep 24, 2012 · Viewed 86.4k times · Source

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?

Answer

solaimuruganv picture solaimuruganv · Sep 24, 2012 
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;

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Read More
pg_dump postgres database from remote server when port 5432 is blocked

I'm trying to pg_dump a SQL database on a remote server in our DMZ. There are 2 problems. 1) there is n't a lot of space left on the remote server so the normal command run to locally backup the database …

Read More