On Tue, Apr 14, 2026 at 1:03 PM Peter Smith <[email protected]> wrote: > > > -- Syntax can be *identical* to the "EXCEPT (TABLE ...)" clause already > pushed. > -- Both of these below are equivalent. > CREATE PUBLICATION pub FOR TABLES IN SCHEMA s1 EXCEPT (TABLE t1, t2, t3); > CREATE PUBLICATION pub FOR TABLES IN SCHEMA s1 EXCEPT (TABLE t1, TABLE > t2, TABLE t3); > > -- Below is an example of multiple schemas and multiple except clauses: > -- publish all tables of schema s1 except s1.t1 and s1.t2 > -- publish all tables of schema s2 > -- publish all tables of schema s3 except table s3.t2 (how is this > ambiguous with the excluded s1.t2?) > CREATE PUBLICATION pub FOR TABLES IN SCHEMA s1 EXCEPT (TABLE t1, t2), > s2, s3 EXCEPT (TABLE t2); >
We can go in the direction as proposed by you but my preference would be to avoid using EXCEPT keyword multiple times. -- With Regards, Amit Kapila.
