Please be aware that the ppl who respond to queries here in the Forums are either volunteers and/or other learners on the CC platform that come here to attempt to help other learners out. We are not perfect; we make mistakes too.
There are guidelines for asking a great question:
And in order to receive a response, other ppl need as much information as possible to understand and/or replicate the issue. Most times, that involves posting your code + an explanation of what you did to receive the error message.
Thankyou for your effort, I already posted a screenshot and the line number where the error occurs.
I can try to fix it but I do not know why they wanted to copy a table again and that there are 29 tables, I am not sure why they wrote some code and how they wanted to design the database
Hi Dav! This is helping me make great progress when I had been running into this issue for awhile now. However, when I run this, I got prompted for the password for my user but was unable to type anything. Do you know how I could add it to the original prompt so it is included?
Here’s how to do that in Windows 10:
1- right click on the windows (Aka “Start button”)
2- select “System” (you can reach there from: Settings - About)
3- in the right menu, click on “Advanced system settings”
4- in the window that popped, click on the bottom button that reads “Environment Variables…”
5- in the upper block, click on the variable that reads “Path” (double-click)
6- in the “Edit environment variable” click new
7- in the new line you should enter your path to \bin folder of your postgreSQL (default for version 13: “C:\Program Files\PostgreSQL\13\bin” yours might be different look it up)
8- back track with “Ok” to close all the 3 open windows.
9- now you can open cmd and enter the command @davbyron provided: psql -U <username> -d <your-baseball-database-name> -f baseball_database.sql
Update: I got all the data to load. It’s been about a week since I tried, but I uninstalled postgres version 13.1 and downloaded postgres version 12.5 instead which may have been the difference (or maybe someone fixed the .sql file not sure either way it works now).
This worked for me. I tried some of the command line stuff with no luck. Simply downloading postgres 12.5 instead of 13 made it all work. I’m using the same SQL file, so it is the version of postgres that is the issue.
Hey everyone, I was facing a major problem when trying to import Baseball.sql file.
I kept getting this error “authentication method 10 not supported”.
I managed to overcome this error by using the SQL Shell (psql) provided after installing PostgreSQL and Postbird, well one of them .
You have to login into the postgres user or whatever user you created
connect to the database you want the data inserted too, I named mine Baseball: postgres=# \c Baseball
Using the ‘\i’ command just select the past the file path for the sql file you want to import: Baseball=# \i '.../TheBestOfBaseballAwards/baseball_database.sql'.
Every time have error like this: Select database ‘baseball’ ERROR: Can not find psql in a system. Make sure PostgreSQL client is installed. On Ubuntu/Debian - package ‘postgresql-client’ On RHEL/Fedora - package ‘postgresql’ FAILURE
Reinstalled Postbird - didn’t help
Reinstalled PostgreSQL to version 12 - didn’t help
Downloaded ‘postgresql client’ - didn’t help
Maybe it’s time to download SQLite and forget about postgres…