You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
pgloader version "3.6.7~devel"
compiled with SBCL 2.2.9.debian
I'm trying to load an sqlite column with the sqlite jsonb type (https://sqlite.org/draft/jsonb.html) into a postgres column with the type jsonb. However the types have incompatible binary formats, when I try to run it I get this:
Pgloader version:
I'm trying to load an sqlite column with the sqlite jsonb type (https://sqlite.org/draft/jsonb.html) into a postgres column with the type jsonb. However the types have incompatible binary formats, when I try to run it I get this:
In sqlite the data will render like this, you can see that what it's trying to load in corresponds to ascii:
I'm running it with:
I have tried with and without casting directives and I can't see a corresponding transformation function
The text was updated successfully, but these errors were encountered: