From: | "Mitra (dot)" <mitraahi(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Error: extra data after last expected column |
Date: | 2016-05-18 21:41:40 |
Message-ID: | CAODUHNVyVbN7iXjLh=NO2opsUCEhntOPhwfQbPiU6OuKpxL=YQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I want to import excel file to postgresql 9.5 but when run the query , got
error :extra data after last expected column
Mac OS
1) downloaded excel file , open with LibreOffice, saved as CSV, UTF-8
(attachment).
2) renamed and moved the file under /Users/<mylogin>/Library/Application
Support/Postgres/var-9.5
3) created an empty table called mytable
4) ran the following command:
query ran under PSequel:
COPY mytable
FROM 'test.csv'
Do I have to create columns inside mytable ? I also tried "Freeze header
and footer" before converting to CSV , same error.
What am I missing here?
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/png | 72.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-05-18 22:04:45 | Re: Error: extra data after last expected column |
Previous Message | Albe Laurenz | 2016-05-18 15:09:22 | Re: Memory and Swap |