The remove table command is used to remove a table from the internal Bucardo database.
Examples:
# Removes the table named "sales" in the public schema from Bucardo.
bucardo remove table public.sales
Database name should be specified if there are two or more tables with same name in different databases.
# Removes the table named "sales" from the database "bazzo" in the public schema from Bucardo.
bucardo remove table public.sales db=bazzo
Usage:
bucardo remove table <name(s)> (db=<dbname>)
Removes one or more tables: the schema is required.
This will not change any running syncs: to do that, you should run:
bucardo reload <syncname>
Items are removed from the goat table. Due to cascading foreign keys, deletion may also remove rows from the herdmap table, the customname table, the customcols table, and the bucardo_custom_trigger table.
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.