Andrew Sullivan ajs
Sat Oct 28 11:56:58 PDT 2006
On Sat, Oct 28, 2006 at 02:40:24PM -0300, Andrew And wrote:
> If in Master I have table with name "TAB_one" and I want to replicate this
> table to slave, but the name in slave need to be "TAB_two". Is this
> possible?
> 
> Master (tab_one) -------replicate-----> slave (tab_two)

On the target machine, copy all the data from tab_one into tab_two. 
Now write a DO INSTEAD trigger on tab_one that writes the data
instead into tab_two.  Poof.

a

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
		--attr. John Maynard Keynes



More information about the Slony1-general mailing list