Re: Problems importing csv files

On Jun 22, 2009, at 19:29, Robert Schnabel <schnabelr(at)missouri(dot)edu>
wrote:

>
> Kindra Martinenko wrote:
>>
>>
>> I tried:
>>
>> COPY BaxterCommercial
>> FROM E'H:\\transpor\\Traffic Counts\\TMS\\MarApr09\
>> \BaxterCommercial.csv'
>> WITH CSV;
>>
>> And it returned with this error:
>>
>>
>> ERROR: relation "baxtercommercial" does not exist
>>
>> Any ideas?
> I'm by no stretch an expert, I'd consider myself a novice, but I ran
> into the same problem when I started. I assume you're using Windows
> right? Does your table name contain uppercase the way you have it
> written above? If it does, try changing the table name to all
> lowercase and change your COPY statement to lowercase. That's what
> worked for me. Scroll to the bottom of this link http://www.postgresql.org/docs/8.0/interactive/ddl.html
> I have resorted to just making sure all of my table names are
> lowercase.