Chapter 4 csv usa_counties2010.csv

[ki4111]

Having trouble with data, code, or exercises in Practical SQL? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days.

Please include the chapter number in your issue title. For example: "Chapter 13: Regular Expression Question"

General

What's your operating system (e.g. , macOS Catalina, Ubuntu, etc.)?

Windows 10
Did you install PostgreSQL and pgAdmin according to the steps on page xxviii of the book's Introduction? If not, please describe your installation.

yes
Which versions of PostgreSQL and pgAdmin 4 are you using? If you aren't sure, for PostgreSQL run the SQL command SELECT version(); and for pgAdmin 4, navigate to "About pgAdmin 4" under the "Help" menu.

Did you download the book's code examples and data from GitHub using the directions on page xxvii of the Introduction? If not, please describe how you loaded the material on your computer.
yes

Issue or Question

Chapter, page and code listing number:
ch 4 usa_counties2010.csv

Describe the issue or your question:

Please answer all of these as they're essential for troubleshooting.
Greetings!
Could you provide the correct CSV file( usa_counties2010.csv), please?
Here's an error which was described in the chapter 4, that there're too many columns.
I tried to fix it by deleting extra columns but that didn't work for me right.
I'd really appreciate a fixed CSV table!
Thanks in advance!
Please paste the code and error message here. It's OK to alter identifying info such as a folder name

[anthonydb]

Hi, there is no problem with the code or data. You must follow the book's instructions as outlined in the Introduction. Please see my reply on this topic on a previous issue here:

#25 (comment)

[anthonydb]

One other thing -- make sure you created the us_counties_2010 table using the code in the repository files, not by copying the code from a PDF of the book!

[ki4111]

Thank you for a quick response)
I guess the second tip is exactly my case.