[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Setting Schema on Restore
From:       Samuel Stearns <SStearns () internode ! com ! au>
Date:       2010-11-30 23:46:24
Message-ID: 68B59BEDCD36854AADBDF17E91B2937A07841888C9 () EXCHMAIL ! staff ! internode ! com ! au
[Download RAW message or body]

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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[prev in list] [next in list] [prev in thread] [next in thread]