Documentation Index
Fetch the complete documentation index at: https://docs.powersync.com/llms.txt
Use this file to discover all available pages before exploring further.
For partitioned tables in Postgres, each individual partition is replicated and processed using Sync Streams (or legacy Sync Rules).
To use the same queries and same output table name for each partition, use % for wildcard suffix matching of the table name:
Sync Streams
Sync Rules (Legacy)
streams:
user_todos:
queries:
# Wildcard matches all user partition tables (e.g. users_2024, users_2025)
- SELECT * FROM "users_%" WHERE id = auth.user_id()
# Wildcard matches all todo partition tables (e.g. todos_2024, todos_2025)
- SELECT * FROM "todos_%" AS todos WHERE user_id = auth.user_id()
by_user:
# Use wildcard in a parameter query
parameters: SELECT id AS user_id FROM "users_%"
data:
# Use wildcard in a data query
- SELECT * FROM "todos_%" AS todos WHERE user_id = bucket.user_id
_table_suffix column. This works the same way in both Sync Streams and Sync Rules:
Sync Streams
Sync Rules (Legacy)
streams:
active_todos:
query: SELECT * FROM "todos_%" AS todos WHERE _table_suffix != 'archived'
SELECT * FROM "todos_%" AS todos WHERE _table_suffix != 'archived'
publish_via_partition_root on the publication is not supported — the individual partitions must be published.
