How can I convert postgresql data to sqlite3 data in linux?

Question

I want to convert my database in postgresql to sqlite3 during upgrading my software

Possible duplicate of How to convert a postgres database to sqlite — Elad
– Elad, Commented Mar 8, 2016 at 7:41

jurhas · Accepted Answer · 2016-03-08 10:07:07Z

0

Normally you do the oposite. If it is small, you take the metadata of each table, copy paste to the gui of sqlite and just change the differents datatype. Programmatically you prepare a list of "INSERT INTO bla bla" one for each row. If you use.net system use stringbuilder to compose the strings. The query must be sorted for the autoincrement value. Than run them. Small tip activate PRAGMA synchronous = OFF in sqlite if you have to insert a huge ammount of rows. Remember to format the data.

answered Mar 8, 2016 at 10:07

jurhas

6631 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jurhas · Accepted Answer · 2016-03-08 10:13:29Z

0

Another solution is prepare a sqlquery:

SELECT 'INSERT INTO tbl_name VALUES(' || v1 || ',' || v2 || ')' 
FROM tbl_name ORDER BY v1 --if is autoincrement

then copy-paste and enjoy

answered Mar 8, 2016 at 10:13

jurhas

6631 gold badge4 silver badges12 bronze badges

Collectives™ on Stack Overflow

How can I convert postgresql data to sqlite3 data in linux?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest