<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Kindra Martinenko wrote:
<blockquote cite="mid:249550(dot)32069(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; color: rgb(0, 0, 0);">
<div>Hello,</div>
<div><br>
</div>
<div>I am having problems importing csv files into postgresql. I am
hoping someone has had a similar problem and could help me troubleshoot.</div>
<div><br>
</div>
<div>
<div>I created a table that mimics the csv table I want to read from.
I set privleges to "All" and have been attempting to execute the
following procedure:</div>
<div><br>
</div>
<div>
<div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">COPY
BaxterCommercial WITH OIDS FROM 'H:\...\BaxterCommercial.csv'</font></div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">USING
DELIMITERS ',';</font></div>
<div><font class="Apple-style-span" face="'Courier New'"><br>
</font></div>
</div>
</div>
</div>
</div>
</blockquote>
You need to escape the \ and maybe use the absolute path.<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.3/interactive/sql-copy.html">http://www.postgresql.org/docs/8.3/interactive/sql-copy.html</a><br>
<br>
If you're using Windows try this but put the full path name instead of
... I use this frequently to load large files.<br>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">COPY
BaxterCommercial WITH OIDS FROM E'H:\\...\\BaxterCommercial.csv'</font></div>
<div><font class="Apple-style-span"
face="'Courier New', courier, monaco, monospace, sans-serif">WITH CSV;</font></div>
<br>
Bob<br>
</body>
</html>