You want to replicate data from multiple tables but exclude some columns from replication. How can you achieve this with logical replication?

hard📝 Application Q9 of 15

PostgreSQL - Advanced Features

ACreate separate publications for each table excluding columns

BCreate a publication for the tables and use row filters or column lists in publication options

CLogical replication does not support excluding columns; use triggers instead

DUse physical replication instead for column filtering

Step-by-Step Solution

Solution:

Step 1: Understand logical replication filtering features
PostgreSQL supports row and column filtering in publications using WHERE clauses and column lists.
Step 2: Identify correct approach
Create a publication for the tables and use row filters or column lists in publication options correctly states using publication options to filter columns and rows.
Final Answer:
Create a publication for the tables and use row filters or column lists in publication options -> Option B
Quick Check:
Use publication options for column filtering [OK]

Quick Trick: Use column lists in publication to exclude columns [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free