I’m trying to migrate from sqlite to postgres and am trying to load the data in via pgloader
.
I have the latest version of pgloader
and keep encountering the error:
ERROR sqlite: Could not prepare an sqlite statement.
Code ERROR: near "nc_audit_index": syntax error.
SQL: PRAGMA index_info(``nc_audit_index``)
Unfortunately there is no further detail.
I’m trying to load the sqlite db file directly:
load database
from 'noco.db'
into postgres://user:password@127.0.0.1:5432/nocodb
with include drop, create tables, create indexes, reset sequences
set work_mem to '16MB', maintenance_work_mem to '512 MB';