Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Sync data from Postgres partitioned tables using wildcard table name matching.
% for wildcard suffix matching of the table name:
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()
table_suffix() function, prefixed with the table name or alias from the FROM clause. This requires PowerSync Service v1.24.0 or later:
config:
edition: 3
streams:
active_todos:
query: SELECT * FROM "todos_%" AS todos WHERE todos.table_suffix() != 'archived'
publish_via_partition_root on the publication is not supported — the individual partitions must be published.