On Tue, Apr 14, 2026 at 5:52 PM Amit Kapila <[email protected]> wrote: > > 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. > > --
Using the "EXCEPT keyword multiple times" wasn't anything different proposed by me. That was already part of the original post. e.g. in the 3rd example. ------ Supported: CREATE PUBLICATION pub FOR TABLES IN SCHEMA s1 EXCEPT (s1.t1), TABLE s2.t1; CREATE PUBLICATION pub FOR TABLE s2.t1, TABLES IN SCHEMA s1 EXCEPT (s1.t1); CREATE PUBLICATION pub FOR TABLES IN SCHEMA s1 EXCEPT (s1.t1), s2 EXCEPT (s2.t1); ------ ====== Kind Regards, Peter Smith. Fujitsu Australia
