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, Jul 09 '21 at 16:13

score 2 · Accepted Answer · answered Jul 09 '21 at 15:17

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 09 '21 at 15:17

jjanes

37,812
5
27
34

Thanks but DBeaver 'execute script' is based on `psql` :((( so it complains that `psql` isn't available. – SkyWalker Jul 09 '21 at 15:55

score 1 · Answer 2 · answered Jul 09 '21 at 16:30

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 09 '21 at 16:30

bfris

5,272
1
20
37

score 1 · Answer 3 · answered Jul 09 '21 at 16:59

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.

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

3 Answers3