Postgres Pro
Downloads
Home   >   mailing lists

Importing CSV File - Mailing list pgsql-general

From David Blomstrom
Subject Importing CSV File
Date
Msg-id CAA54Z0jmDg-n5xbqiMBgsF8+qSUvm34dUqLKtbhh7-mGTA-Sjw@mail.gmail.com
Whole thread Raw
Responses Re: Importing CSV File  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Importing CSV File  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Importing CSV File  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Importing CSV File  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: David Blomstrom
Date:
Subject: Re: Recursive Arrays 101
Next
From: Adrian Klaver
Date:
Subject: Re: Recursive Arrays 101