Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz;

PostgreSQL 19 extends ALTER PUBLICATION to support the EXCEPT TABLE clause, complementing the earlier CREATE PUBLICATION EXCEPT TABLE feature. The new syntax allows modifying the exclusion list for publications that cover ALL TABLES. When SET ALL TABLES EXCEPT TABLE is used, the existing exclusion list is fully replaced by the specified tables — it does not merge with the previous list. Practical examples demonstrate creating publications, excluding specific tables, and updating exclusion lists across multiple publications.