Import data from PostgreSQL to SQLite

Click "Import From Query" at task dialog.

Import data from PostgreSQL Query To SQLite Table - task window

then show the Import Query form.

1. Enter Source Query.

Import data from PostgreSQL Query To SQLite Table - enter query

2. Select Target Table

Import data from PostgreSQL Query To SQLite Table - enter file name

3. Summary.

Import data from PostgreSQL Query To SQLite Table - summary

4. Import.

Import data from PostgreSQL Query To SQLite Table - export

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.