RE: row filtering for logical replication

> 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(dot)kapila16(at)gmail(dot)com>
Sent: Thursday, February 24, 2022 11:25 AM
To: Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi(dot)shinoda(at)hpe(dot)com>
Cc: Euler Taveira <euler(at)eulerto(dot)com>; houzj(dot)fnst(at)fujitsu(dot)com; Peter Smith <smithpb2250(at)gmail(dot)com>; Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>; Greg Nancarrow <gregn4422(at)gmail(dot)com>; vignesh C <vignesh21(at)gmail(dot)com>; Ajin Cherian <itsajin(at)gmail(dot)com>; tanghy(dot)fnst(at)fujitsu(dot)com; Dilip Kumar <dilipbalaut(at)gmail(dot)com>; Rahila Syed <rahilasyed90(at)gmail(dot)com>; Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>; Önder Kalacı <onderkalaci(at)gmail(dot)com>; japin <japinli(at)hotmail(dot)com>; Michael Paquier <michael(at)paquier(dot)xyz>; David Steele <david(at)pgmasters(dot)net>; Craig Ringer <craig(at)2ndquadrant(dot)com>; Amit Langote <amitlangote09(at)gmail(dot)com>; PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: row filtering for logical replication

On Thu, Feb 24, 2022 at 7:43 AM Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi(dot)shinoda(at)hpe(dot)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.