3

I'm trying to use the pg_dump command to generate a file from the whole database which includes some tables from Postgresql:

pg_dump -h <my postgres host> -U <my user name> -Fc <my database name> > pg.dump

I want to convert this pg.dump file to pg.sqlite, but I don't know how to do it.

Improve this question
2
  • Do not use the custom format, use insert statements. After that some manual work may be needed, but it's a lot simpler. Commented Jun 3, 2015 at 8:31
  • 6
    possible duplicate of How to convert a postgres database to sqlite Commented Jun 3, 2015 at 9:05
Related questions
152
How to convert SQLite SQL dump file to PostgreSQL?
41
How to convert a postgres database to SQLite?
737
Import SQL dump into PostgreSQL database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.