Is there an alternative way to import data into Postgres than using psql?

Question

I am under strict corporate environment and don't have access to Postgres' psql. Therefore I can't do what's shown e.g. in the SO Convert SQLITE SQL dump file to POSTGRESQL. However, I can generate the sqlite dump file .sql. The resulting dump.sql file is 1.3gb big.

What would be the best way to import this data into Postgres? I also have DBeaver and can connect to both databases simultaneously but unfortunately can't do INSERT from SELECT.

What can you access other than a crippled DBeaver? Perl? Python? R? — jjanes
– jjanes, Commented Jul 9, 2021 at 16:13

jjanes · Accepted Answer · 2021-07-09 15:17:00Z

2

I think the term for that is 'absurd', not 'strict'.

DBeaver has an 'execute script' feature. But who knows, maybe it will be blocked.

answered Jul 9, 2021 at 15:17

jjanes

45k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SkyWalker Over a year ago

Thanks but DBeaver 'execute script' is based on psql :((( so it complains that psql isn't available.

bfris · Accepted Answer · 2021-07-09 16:30:50Z

1

EnterpriseDB offers binary downloads. If you unzip those to a local drive you might be able to execute psql from the bin subdirectory.

answered Jul 9, 2021 at 16:30

bfris

5,9332 gold badges26 silver badges45 bronze badges

Comments

jjanes · Accepted Answer · 2021-07-09 16:59:48Z

1

If you can install psycopg2 or pg8000 for python, you should be able to connect to the database and then loop over the dump file sending each line to the database with cur.execute(line) . It might take some fiddling if the dump file has any multi-line commands, but the example you linked to doesn't show any of those.

answered Jul 9, 2021 at 16:59

jjanes

45k5 gold badges39 silver badges48 bronze badges

Collectives™ on Stack Overflow

Is there an alternative way to import data into Postgres than using psql?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related