Samuel Stearns <SStearns(at)internode(dot)com(dot)au> writes:
> I want to restore into a specific schema.
The only way to do that is to hand-edit the dump script.
If you're feeling brave you could try letting "sed" do it; but
unless the schema name being replaced is pretty unusual, the
risk of false matches seems high.
regards, tom lane