論理レプリケーションにおける列リスト － PostgreSQL 15でコミットされた機能の紹介：技術者Blog
PostgreSQLインサイド

CREATE PUBLICATION <pub-name> FOR TABLE <table-name>[(column-list)]
ALTER PUBLICATION <pub-name> ADD TABLE <table-name>[(column-list)]
ALTER PUBLICATION <pub-name> SET TABLE <table-name>[(column-list)]

<column-list> ::= <column-list-item> [,<column-list>]
<column-list-item> ::= <column-name>

CREATE PUBLICATION salary_information FOR TABLE employee (user_id, name, salary);

postgres=# CREATE TABLE employee (emp_no INTEGER NOT NULL, name VARCHAR, phone VARCHAR, email VARCHAR, address VARCHAR, dept_no INTEGER, birthday DATE, salary INTEGER);
CREATE TABLE
Postgres=# CREATE TABLE department (dept_no INTEGER NOT NULL, dept_name VARCHAR, mgr_no INT, location VARCHAR);
CREATE TABLE
postgres=# CREATE PUBLICATION pub_emp FOR TABLE employee;
CREATE PUBLICATION
-- Publication can be altered to include another table with specified -- columns.
postgres=# ALTER PUBLICATION pub_emp ADD TABLE department(dept_no, dept_name);
ALTER PUBLICATION
postgres=# CREATE PUBLICATION pub_emp_birthday FOR TABLE employee(emp_no, birthday);
CREATE PUBLICATION
postgres=# CREATE PUBLICATION pub_emp_email FOR TABLE employee(emp_no, email);
CREATE PUBLICATION
postgres=# ¥d employee
                    Table "public.employee"
  Column  |       Type        | Collation | Nullable | Default
----------+-------------------+-----------+----------+---------
 emp_no   | integer           |           | not null |
 name     | character varying |           |          |
 phone    | character varying |           |          |
 email    | character varying |           |          |
 address  | character varying |           |          |
 dept_no  | integer           |           |          |
 birthday | date              |           |          |
 salary   | integer           |           |          |
Publications:
    "pub_emp"
    "pub_emp_birthday" (emp_no, birthday)
    "pub_emp_email" (emp_no, email)
postgres=# ¥dRp+
                            Publication pub_emp
  Owner  | All tables | Inserts | Updates | Deletes | Truncates | Via root
---------+------------+---------+---------+---------+-----------+----------
 vignesh | f          | t       | t       | t       | t         | f
Tables:
    "public.department" (dept_no, dept_name)
    "public.employee"

                       Publication pub_emp_birthday
  Owner  | All tables | Inserts | Updates | Deletes | Truncates | Via root
---------+------------+---------+---------+---------+-----------+----------
 vignesh | f          | t       | t       | t       | t         | f
Tables:
    "public.employee" (emp_no, birthday)

                         Publication pub_emp_email
  Owner  | All tables | Inserts | Updates | Deletes | Truncates | Via root
---------+------------+---------+---------+---------+-----------+----------
 vignesh | f          | t       | t       | t       | t         | f
Tables:
    "public.employee" (emp_no, email)
postgres=#

CREATE PUBLICATION pub_data_staff_email
FOR TABLE staff(name, email, dept_id, salary);

CREATE PUBLICATION pub_data_city_population
FOR TABLE city(name, population);

CREATE PUBLICATION pub_data_customer_investment FOR TABLE customer_account(name, phone, investment);