|
On 10/27/2015 10:04 AM, Adrian Klaver
wrote:
On
10/27/2015 08:44 AM, Jeff Janes wrote:
On Mon, Oct 26, 2015 at 2:45 PM, David
Blomstrom
<david.blomstrom@xxxxxxxxx
<mailto:david.blomstrom@xxxxxxxxx>> 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?
How does it know when to stop ignoring and start the next
record?
I wondered about that also. I did find this:
http://dev.mysql.com/doc/refman/5.7/en/load-data.html
LINES TERMINATED BY
You could write a little awk or perl script to give the PROGRAM
option
of copy, but you can't do that within pgAdmin.
Cheers,
Jeff
Whence the csv file?
If it starts out in spreadsheet, can you not export only the columns
you want in the database?
Google "postgres import tool" finds several options
|
