fullcopy is a type of Bucardo sync that copies an entire table from one database (the source) to one or more target databases. Any rows on the targets are removed first, and the table is populated using the COPY command. This is the only sync that can be used for tables that have no primary key and no unique index. Because it copies the entire table every time, it is not efficient and should not be run often for large tables. It is far better in most cases to add a unique index to the table and then use a pushdelta sync to keep things up to date.

The contents of the table can be modified as they are copied over, by setting the customselect field of the sync. This should be a SELECT statement that returns some subset of the original table’s columns. It must contain at least the columns used in the primary key or unique index.