On 27/10/15 10:45, David Blomstrom wrote:
> 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.
You can import the CSV into a spreadsheet (such as LibreOffice Calc),
and manually delete the extraneous lines.