Either pre-process the CSV file, or (what I probably would do) import into a temporary copy of the target table and INSERT only selected rows in a second step:

CREATE TEMP TABLE tmp AS SELECT * FROM target_table LIMIT 0;
COPY tmp FROM '/path/tp/file.csv';

INSERT INTO target_table
SELECT * FROM tmp
WHERE  ...


A temporary table is dropped automatically at the end of the session. If the processing takes longer, use a regular table.

COPY command: copy only specific columns from csv

  Possible Duplicate:
  Windows 7 unidentified network direct cable connection  




I connect the internet through Ad-hoc network, My machine uses win7 and another uses winows xp, There's no problem when I connect the XP machine, but if i disconnect and reconnect the net, then my local network is marked as "Unidentified network",unless restart the XP machine, I don't know why? 
