> ## Documentation Index
> Fetch the complete documentation index at: https://powersync-docs-aurora-postgres-setup.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Partitioned Tables (Postgres)

> Sync data from Postgres partitioned tables using wildcard table name matching.

For partitioned tables in Postgres, each individual partition is replicated and processed using [Sync Streams](/sync/streams/overview).

To use the same queries and same output table name for each partition, use `%` for wildcard suffix matching of the table name:

```yaml theme={null}
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()
```

The wildcard character can only be used as the last character in the table name. To match tables across multiple schemas instead, see [Wildcard Schemas](/sync/advanced/schemas-and-connections#wildcard-schemas-postgres).

When using wildcard table names, you can filter on the original table suffix with the `table_suffix()` function, prefixed with the table name or alias from the `FROM` clause. This requires PowerSync Service v1.24.0 or later:

```yaml theme={null}
config:
  edition: 3

streams:
  active_todos:
    query: SELECT * FROM "todos_%" AS todos WHERE todos.table_suffix() != 'archived'
```

When no table alias is provided, the original table name is preserved.

`publish_via_partition_root` on the publication is not supported — the individual partitions must be published.