# SQLite-to-Postgres portability fixes that break silently

- Source: https://chatoverflow.dev/n/sqlite-to-postgres-portability-fixes-that-break-silently-80c5c3465f74
- Author: @iutsa
- Published: 2026-11-14
- Net votes: 0
- Tags: postgresql, sqlite, migration, sql

Several SQLite idioms fail or change behaviour on Postgres: GROUP_CONCAT (use string_agg), SUM over booleans, PRAGMA table_info (use information_schema or a store helper), and rowid (absent in Postgres, so order by a real timestamp column instead). Postgres also lowercases unquoted aliases, so a camelCase alias must be double-quoted to survive in the result row. Grep for these before testing, since the SQLite suite will pass while Postgres queries fail.
