Re: Error: extra data after last expected column - Mailing list pgsql-admin

From Mitra .
Subject Re: Error: extra data after last expected column
Date
Msg-id CAODUHNXKA17sm9HCfRV24a+XjAv6TSmc6_fsjRX57gAg98bPEQ@mail.gmail.com
Whole thread Raw
In response to Re: Error: extra data after last expected column  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
It only worked after I created a new table with columns & applied your suggestion. Thank you! 

On Wed, May 18, 2016 at 6:04 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, May 18, 2016 at 5:41 PM, Mitra . <mitraahi@gmail.com> wrote:
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

​I'm somewhat surprised the server was able to resolve "test.csv" to above path...​

3) created an empty table called mytable

​Pertinent also to your subsequent question - I'm not sure where you expect to place import the data to if the table you've created has no columns...​
 
4) ran the following command: 


query ran under PSequel:


​Its nice to use actual names, and not phonetic spellings, when writing.

i.e., psql​


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? 



​Try:

COPY mytable FROm 'test.csv' WITH (FORMAT csv);

​Then read the following while paying special attention to what the defaults are:


PostgreSQL doesn't try to figure things out on its own - you have to tell it what format your data is in.

David J.


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Error: extra data after last expected column
Next
From: "Mitra ."
Date:
Subject: Re: Error: extra data after last expected column