Thanks, Tom! -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, 1 December 2010 1:37 AM To: Samuel Stearns Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Setting Schema on Restore Samuel Stearns <SStearns@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin