Message-Id: 
 <1450369108.2740801.470182945.59E4E975@webmail.messagingengine.com>
From: CN <cnliou9@fastmail.fm>
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: multipart/alternative;
 boundary="_----------=_145036910827408010";
 charset="utf-8"
Subject: Re: feature request: pg_restore renaming target schema
Date: Fri, 18 Dec 2015 00:18:28 +0800
In-Reply-To: 
 <CABzCKRCYkP400=0ZqOKPsYEb7twKjX8fcQ96hFMGf+6ZsGys=A@mail.gmail.com>
References: 
 <1450338245.2626908.469822713.6C14EE8F@webmail.messagingengine.com>
 <CAGDYbUNK2tQZz4SfFBZit8o5wqHgy3Hz3SOgVhxkHh3aZ1DOwg@mail.gmail.com>
 <1450365586.2726209.470114761.326B7E39@webmail.messagingengine.com>
 <CABzCKRCYkP400=0ZqOKPsYEb7twKjX8fcQ96hFMGf+6ZsGys=A@mail.gmail.com>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

--_----------=_145036910827408010
Content-Transfer-Encoding: 7bit
Content-Type: text/plain

On Thu, Dec 17, 2015, at 11:34 PM, John Scalia wrote:
> Maybe a bit off-postgresql, but why couldn't you just add to your
> existing automations script, Use sed or your favorite stream editor
> and have that do the renaming in the dump output? FWIW, Jay
> or over the web

I thought this approach before I raised this request. I had peeked the
dumped file and had a feeling that manipulating the dumped file with
stream editors was infeasible because I thought that the source schema
name was scrambled everywhere in the dumped file, data included.

Having received your message, I started to think that the approach I
gave up in the very beginning might actually be the feasible one -
thinking that you would not have mentioned it otherwise!

Hence I went back and took a more thorough look at the dumped file and
happily to find that it *appears* to me that I only need to edit the
first several lines of the dumped file in addition to such lines:

ALTER FUNCTION <schema name>.my_function(....) OWNER TO ....

With that said, the appearance pattern of source schema name in the
dumped file seems to be predictable. I will study more to make sure
stream editors can do this job.

Many thanks for the hint!

Best Regards, CN

-- 
http://www.fastmail.com - The professional email service


--_----------=_145036910827408010
Content-Transfer-Encoding: 7bit
Content-Type: text/html

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body><div>On Thu, Dec 17, 2015, at 11:34 PM, John Scalia wrote:</div>
<blockquote type="cite"><div dir="ltr"><div>Maybe a bit off-postgresql, but why couldn't you just add to your existing automations script, Use sed or your favorite stream editor and have that do the renaming in the dump output?</div>
<div>FWIW,</div>
<div>Jay<span><span class="colour" style="color:rgb(136, 136, 136)">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; or over the web&nbsp;</span></span></div>
</div>
</blockquote><div>&nbsp;</div>
<div>I thought this approach before I raised this request. I had peeked the dumped file and had a feeling that manipulating the dumped file with stream editors was infeasible because I thought that the source schema name was scrambled everywhere in the dumped file, data included.</div>
<div>&nbsp;</div>
<div>Having received your message, I started to think that the approach I gave up in the very beginning might actually be the feasible one - thinking that you would not have mentioned it otherwise!</div>
<div>&nbsp;</div>
<div>Hence I went back and took a more thorough look at the dumped file and happily to find that it *appears* to me that I only need to edit the first several lines of the dumped file in addition to such lines:</div>
<div>&nbsp;</div>
<div>ALTER FUNCTION &lt;schema name&gt;.my_function(....) OWNER TO ....</div>
<div>&nbsp;</div>
<div>With that said, the appearance pattern of source schema name in the dumped file seems to be predictable. I will study more to make sure stream editors can do this job.</div>
<div>&nbsp;</div>
<div>Many thanks for the hint!</div>
<div>&nbsp;</div>
<div>Best Regards,</div>
<div>CN</div>
<pre>
-- 
http://www.fastmail.com - The professional email service
</pre>
</body>
</html>

--_----------=_145036910827408010--