Filtering specific rows from table

[srinivasan554]

I have two questions to clarify regarding moving specific rows only to target table

1. I need to migrate some rows only from public schema's table into target schema's table within a database. I had tried customcols ( https://bucardo.org/Bucardo/operations/customselect ) with where clause but it doesn't work. How can I do this using bucardo?

2. Alternatively i tried adding constraint check in target table. In that, the row is not getting added in source table itself if target table constraint fails. Any idea on this too?

Thanks in advance

[srinivasan554]

@jonjensen could you please help on this?

[jonjensen]

@srinivasan554 Sorry, I don't have any quick answers for you.