> 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 <amit.kapil...@gmail.com> Sent: Thursday, February 24, 2022 11:25 AM To: Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi.shin...@hpe.com> Cc: Euler Taveira <eu...@eulerto.com>; houzj.f...@fujitsu.com; Peter Smith <smithpb2...@gmail.com>; Alvaro Herrera <alvhe...@alvh.no-ip.org>; Greg Nancarrow <gregn4...@gmail.com>; vignesh C <vignes...@gmail.com>; Ajin Cherian <itsa...@gmail.com>; tanghy.f...@fujitsu.com; Dilip Kumar <dilipbal...@gmail.com>; Rahila Syed <rahilasye...@gmail.com>; Peter Eisentraut <peter.eisentr...@enterprisedb.com>; Önder Kalacı <onderkal...@gmail.com>; japin <japi...@hotmail.com>; Michael Paquier <mich...@paquier.xyz>; David Steele <da...@pgmasters.net>; Craig Ringer <cr...@2ndquadrant.com>; Amit Langote <amitlangot...@gmail.com>; PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org> Subject: Re: row filtering for logical replication On Thu, Feb 24, 2022 at 7:43 AM Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi.shin...@hpe.com> 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.
