Re: command line v GUI and COPY

On 10/14/2014 12:11 PM, jared wrote:
> for GUI, do you have pgadmin installed?
Yes. I created the DB "FIA" with it and in the tree under "Tables",
right-clicking has an option for New Table, but I don't know which of
the tabs, if any, let me import existing data at the time of creating
the new table in the pgadmin menu.

> For the 'extra data after the last column'
>
> The error should have given you a row number. Did you open up the
> file and that row number and make sure there wasn't?
This is how the data originally appears in the file. The error says it
was in row 2. It looked like there was an extra pair of quotes and then
an odd quote at the very end.
"CN","PLT_CN","INVYR","STATECD","UNITCD","COUNTYCD","PLOT","SUBP","SUBPTYP","BNDCHG","CONTRAST","AZMLEFT","AZMCORN","DISTCORN","AZMRIGHT","CYCLE","SUBCYCLE","CREATED_BY","CREATED_DATE","CREATED_IN_INSTANCE","MODIFIED_BY","MODIFIED_DATE","MODIFIED_IN_INSTANCE"
"202492243010854","157287634010478",2008,40,1,5,131,2,1,,2,276,0,,70,7,1,"",2011-05-02,"10854","",,""

I used Notepad++ to open the file and get rid of the quotes and just
leave the trailing commas for the three empty fields. Still the same
error message. I tried again, deleting the commas trailing after "10854"
to see if that would get rid of the problem. Just in case, I opened in
LibreOffice Calc, I can't see any other contents in the cells. I
couldn't find anything in the fields, tried to delete them anyway.
Searched the web and came across the comment about adding to an existing
table. I still don't know what's causing the problem.

John