Thanks, Tom!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, 1 December 2010 1:37 AM
To: Samuel Stearns
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Setting Schema on Restore
Samuel Stearns <SStearns@internode.com.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