Case Sensitivity

Sync Rules are deprecated. This page applies to both Sync Streams and Sync Rules unless a section says otherwise.

Case in Sync Queries

PowerSync converts all table/collection and column/field names to lower-case by default in sync queries (this is how Postgres also behaves). To preserve the case, surround the names with double quotes, for example:

SELECT "ID" as id, "Description", "ListID" FROM "TODOs"

When using SELECT *, the original case is preserved for the returned columns/fields.

Client-Side Case

On the client side, the case of table and column names in the client-side schema must match the case produced by the sync query exactly. For the above example, use the following in Dart:

  Table('TODOs', [
    Column.text('Description'),
    Column.text('ListID')
  ])

SQLite itself is case-insensitive. When querying and modifying the data on the client, any case may be used. For example, the above table may be queried using SELECT description FROM todos WHERE listid = ?.

Operations (PUT/PATCH/DELETE) are stored in the upload queue using the case as defined in the schema above for table and column names, not the case used in queries.

As another example, in this sync query:

SELECT ID, todo_description as Description FROM todo_items as TODOs

Each identifier in the example is unquoted and converted to lower case. That means the client-side schema would be:

Table('todos', [
  Column.text('description')
])

Get Started

Configuration Details

Sync Streams

Client SDKs

Handling Writes

Maintenance & Ops

Integrations

Tools

Resources

Case in Sync Queries

Client-Side Case

​Case in Sync Queries

​Client-Side Case

Case in Sync Queries

Client-Side Case