12
Best way to convert sqlite database to postgresql database? (solved)
(programming.dev)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 02 Aug 2023
12 points (83.3% liked)
Web Development
5796 readers
40 users here now
Welcome to the web development community! This is a place to post, discuss, get help about, etc. anything related to web development
What is web development?
Web development is the process of creating websites or web applications
Rules/Guidelines
- Follow the programming.dev site rules
- Keep content related to web development
- If what you're posting relates to one of the related communities, crosspost it into there to help them grow
- If youre posting an article older than two years put the year it was made in brackets after the title
Related Communities
- !html@programming.dev
- !css@programming.dev
- !uiux@programming.dev
- !a11y@programming.dev
- !react@programming.dev
- !vuejs@programming.dev
- !webassembly@programming.dev
- !javascript@programming.dev
- !typescript@programming.dev
- !nodejs@programming.dev
- !astro@programming.dev
- !angular@programming.dev
- !tauri@programming.dev
- !sveltejs@programming.dev
- !pwa@programming.dev
Wormhole
Some webdev blogs
Not sure what to post in here? Want some web development related things to read?
Heres a couple blogs that have web development related content
- https://frontendfoc.us/ - [RSS]
- https://wesbos.com/blog
- https://davidwalsh.name/ - [RSS]
- https://www.nngroup.com/articles/
- https://sia.codes/posts/ - [RSS]
- https://www.smashingmagazine.com/ - [RSS]
- https://www.bennadel.com/ - [RSS]
- https://web.dev/ - [RSS]
founded 3 years ago
MODERATORS
I have tried it. Getting this error: The value NIL is not of type STRING when binding STRING
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 ___
You need to provide a password in the connection string. https://pgloader.readthedocs.io/en/latest/pgloader.html?highlight=password#connection-string
Thanks man. It worked
You might need to handle NULL values by explicit type casting