擅长:python、mysql、java
<p>由于您希望一次读取并存储一行,因此<a href="http://docs.python.org/library/csv.html" rel="nofollow">Python csv module</a>应该可以使您轻松地从CSV文件中读取前3列,而不考虑任何额外的列。在</p>
<p>您可以构造一个INSERT语句,并使用首选的Python PostGreSQL模块执行它。我以前用过pyPgSQL;不知道现在是什么。在</p>
<pre><code>#!/usr/bin/env python
import csv
filesource = 'PeopleAndResources.csv'
with open(filesource, 'rb') as f:
reader = csv.reader(f, delimiter=';', quotechar='"')
for row in reader:
statement = "INSERT INTO ImportCSVTable " + \
"(name, address, phone) " + \
"VALUES ('%s', '%s', '%s')" % (tuple(row[0:3]))
#execute statement
</code></pre>