On 5 Jul 2015, at 1:44pm, c.buhtz at posteo.jp wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database?
Dump the Postgres database to a text file of SQL commands. Then use the SQLite command-line tool to .read that text file. <http://www.postgresql.org/docs/9.4/static/backup-dump.html> <https://www.sqlite.org/download.html> <https://www.sqlite.org/cli.html> There may be some minor differences in the two versions of SQL and you may have to deal with them before SQLite will .read your file. If you're not sure of equivalents post here and we'll try to help. Simon.
