<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Kindra Martinenko wrote:
<blockquote cite="mid:448995(dot)80419(dot)qm(at)web30207(dot)mail(dot)mud(dot)yahoo(dot)com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><br>
<div>I tried:</div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif"><br>
</font></div>
<div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">COPY
BaxterCommercial </font></div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">FROM
E'H:\\transpor\\Traffic Counts\\TMS\\MarApr09\\BaxterCommercial.csv'</font></div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">WITH CSV;</font></div>
<div><font class="Apple-style-span" face="'Courier New'"><br>
</font></div>
<div><font class="Apple-style-span"
face="arial, helvetica, sans-serif">And it returned with this error:</font></div>
<div><font class="Apple-style-span" face="'Courier New'"><br>
</font></div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif"><br>
</font></div>
</div>
<div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><font
class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">ERROR:
relation "baxtercommercial" does not exis</font>t</div>
<div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><br>
</div>
<div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">Any
ideas? </div>
</div>
</blockquote>
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
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.0/interactive/ddl.html">http://www.postgresql.org/docs/8.0/interactive/ddl.html</a> I have
resorted to just making sure all of my table names are lowercase.<br>
</body>
</html>