0

I have a postgres database on the server and we are building a iPhone app and need the database in Sqlite format.

Someone has already asked this question but the linked tools are mostly windows based GUI tools. Is there a linux friendly tool to do this.

Community
  • 1
  • 1
shabda
  • 1,668
  • 1
  • 18
  • 28

1 Answers1

1

pg_dump --column-inserts should give you a good starting point for a script to recreate the database in SQLite. It should then be possible to write something to transform this SQL and convert types and concepts, e.g. presumably sequences for primary keys will have to be converted to auto-inc qualifications?

araqnid
  • 127,052
  • 24
  • 157
  • 134