From: | Samuel Stearns <SStearns(at)internode(dot)com(dot)au> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Setting Schema on Restore |
Date: | 2010-11-30 23:34:24 |
Message-ID: | 68B59BEDCD36854AADBDF17E91B2937A07841888C9@EXCHMAIL.staff.internode.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | bakkiya | 2010-12-01 05:51:17 | Postgres problem with partition queries |
Previous Message | Kevin Grittner | 2010-11-30 18:53:44 | Re: Space occupied by Postgres index. |