> You can give it for multiple tables. See below as an example: Thank you very much. I understood.
Regards, Noriyoshi Shinoda -----Original Message----- From: Amit Kapila <[email protected]> Sent: Thursday, February 24, 2022 11:25 AM To: Shinoda, Noriyoshi (PN Japan FSIP) <[email protected]> Cc: Euler Taveira <[email protected]>; [email protected]; Peter Smith <[email protected]>; Alvaro Herrera <[email protected]>; Greg Nancarrow <[email protected]>; vignesh C <[email protected]>; Ajin Cherian <[email protected]>; [email protected]; Dilip Kumar <[email protected]>; Rahila Syed <[email protected]>; Peter Eisentraut <[email protected]>; Önder Kalacı <[email protected]>; japin <[email protected]>; Michael Paquier <[email protected]>; David Steele <[email protected]>; Craig Ringer <[email protected]>; Amit Langote <[email protected]>; PostgreSQL Hackers <[email protected]> Subject: Re: row filtering for logical replication On Thu, Feb 24, 2022 at 7:43 AM Shinoda, Noriyoshi (PN Japan FSIP) <[email protected]> wrote: > > Hi, > Thank you for developing of the great feature. > If multiple tables are specified when creating a PUBLICATION, is it > supposed that the WHERE clause condition is given to only one table? > You can give it for multiple tables. See below as an example: > --- operation log --- > postgres=> CREATE TABLE data1(c1 INT PRIMARY KEY, c2 VARCHAR(10)); > CREATE TABLE postgres=> CREATE TABLE data2(c1 INT PRIMARY KEY, c2 > VARCHAR(10)); CREATE TABLE postgres=> CREATE PUBLICATION pub1 FOR > TABLE data1,data2 WHERE (c1 < 1000); CREATE PUBLICATION postgres=# CREATE PUBLICATION pub_data_1 FOR TABLE data1 WHERE (c1 > 10), data2 WHERE (c1 < 1000); CREATE PUBLICATION -- With Regards, Amit Kapila.
