Re: Setting Schema on Restore

Thanks, Tom!

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, 1 December 2010 1:37 AM
To: Samuel Stearns
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Setting Schema on Restore

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