depesz

PostgreSQL 19 introduces the EXCEPT TABLE syntax for CREATE PUBLICATION ... FOR ALL TABLES, allowing specific tables to be excluded from logical replication publications. Previously, replicating all tables except a few required explicitly listing every desired table. Now you can write `CREATE PUBLICATION p3 FOR ALL TABLES EXCEPT TABLE (public.t5, s1.t1)` and those tables will be skipped. The exclusion also works at the root level for partitioned tables, covering all current and future partitions. ALTER PUBLICATION support for managing exclusions is planned as follow-up work.

Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE. – select * from depesz;