I have a problem when I try to import a file to PostgreSQL.

I’m using Postgresql 16.3 on Windows but whenever I try to import a new file (.sql) it doesn’t work! My process on Postbird: File -> Import .sql file -> I select my sql file -> Import database -> Error! And it shows me an error that says:

” Import Options Importing File:
C:UsersaorlaDownloadsTheBestOfBaseballAwardsbaseball_dataset.sql
Select database ‘baseball’ psql: authentication method 10 not supported FAILURE “

The error on Postbird

I even tried some other methods, like going to SQL shell directly and try it from there using: “i C:UsersaorlaDownloadsTheBestOfBaseballAwardsbaseball_dataset.sql” but it threw me an error again, saying:

“C:: Permission denied”.

I was expecting that this would solve the problem but it didn’t.

Then, I also tried from cmd using this command:

psql --host=localhost --port=5432 --dbname=baseball --username=postgres --files=C:\Users\aorla\Downloads\TheBestOfBaseballAwards\baseball_dataset.sql

And it’s error:

psql: illegal option — files=C:UsersaorlaDownloadsTheBestOfBaseballAwardsbaseball_dataset.sql psql: hint: Try “psql –help” for more information.”