Re: Importing CSV File - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Importing CSV File
Date
Msg-id 562EA1BC.3040505@aklaver.com
Whole thread Raw
In response to Importing CSV File  (David Blomstrom <david.blomstrom@gmail.com>)
List pgsql-general
On 10/26/2015 02:45 PM, 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?

Is it really /r/n not \r\n?

>
> Thanks.


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Recursive Arrays 101
Next
From: Gavin Flower
Date:
Subject: Re: Importing CSV File