Postgres JSONB columns are converted to Sqlite TEXT columns, not JSON

simonw / db-to-sqlite

CLI tool for exporting tables or queries from any SQL database to a SQLite file

Apache License 2.0

370 stars 29 forks source link

Postgres JSONB columns are converted to Sqlite TEXT columns, not JSON #53

Open manuelmeurer opened 1 year ago

manuelmeurer commented 1 year ago

After converting a db from Postgres (15) to Sqlite, I noticed that the Postgres JSONB columns were turned into Sqlite TEXT columns. Wouldn't it make more sense to turn them into JSON columns?