this post was submitted on 02 Aug 2023
12 points (87.5% liked)

Web Development

0 readers
1 users here now

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 2 years ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
12
Best way to convert sqlite database to postgresql database? (solved) (programming.dev)
submitted 2 years ago* (last edited 2 years ago) by Timely_Jellyfish_2077@programming.dev to c/webdev@programming.dev
11 comments fedilink hide all child comments
 

I have been trying to import this sqlite database into mysql or postgresql database. But had been failing. Can anyone help me with this?

you are viewing a single comment's thread
view the rest of the comments
[–] Timely_Jellyfish_2077@programming.dev 1 points 2 years ago (2 children)

I have tried it. Getting this error: The value NIL is not of type STRING when binding STRING

[–] pfannkuchen@lemmy.world 1 points 2 years ago

You might need to handle NULL values by explicit type casting

[–] Timely_Jellyfish_2077@programming.dev 1 points 2 years ago* (last edited 2 years ago) (1 children)

Full error message: DB-CONNECTION-ERROR: Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING An unhandled error condition has been signalled: Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING

What I am doing here?

Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING ___