Importing CSV File

From: David Blomstrom <david(dot)blomstrom(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Importing CSV File
Date: 2015-10-26 21:45:45
Message-ID: CAA54Z0jmDg-n5xbqiMBgsF8+qSUvm34dUqLKtbhh7-mGTA-Sjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-10-26 21:47:31 Re: Recursive Arrays 101
Previous Message David Blomstrom 2015-10-26 21:26:24 Re: Recursive Arrays 101