postgresqlpg-dumppg-restore

I want to restore the database with a different schema

I have taken a dump of a database named temp1, by using the follwing command 

$  pg_dump -i -h localhost  -U postgres -F c -b -v -f pub.backup temp1

Now I want to restore the dump in a different database called "db_temp" , but in that I just want that all the tables should be created in a "temp_schema" ( not the default schema which is in the fms temp1 database ) which is in the "db_temp" database.

Is there any way to do this using pg_restore command?

Any other method also be appreciated!

Solution

  • There's no way in pg_restore itself. What you can do is use pg_restore to generate SQL output, and then send this through for example a sed script to change it. You need to be careful about how you write that sed script though, so it doesn't match and change things inside your data.