[Bucardo-general] Replication to a different schema

Greg Sabino Mullane greg at endpoint.com
Sat Feb 9 16:17:48 UTC 2013

On Sat, Feb 09, 2013 at 03:19:20PM +0100, Csaba Simon wrote:
> Hi,
> I would like to replicate a table to a schema with different name, I mean
> schema name of the table in target database differs from the source schema
> name. I found the term "customname" in glossary of Bucardo documentation,
> but I cannot find how to use it. Or should I use "customcode" feature? How
> does it work?

Yes, customname is what you want. If the source database has a table 
named public.foobar and you want the target database (let's call it B) 
to receive things in the "sales" schema, you would run:

bucardo add customname public.foobar sales.foobar db=B

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130209/aa65e07f/attachment.sig>

More information about the Bucardo-general mailing list