I tried to import a CSV file into a PostgreSQL table using pgAdmin III. I got an error message: "extra data after last column."
All my spreadsheets have an "end of data" column that has /r/n in each cell. When I import a CSV file into a MySQL table, everything beyond /r/n is ignored. Is there some way to tell PostgreSQL to stop at /r/n?
Thanks.