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 | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
