Howto

Import from CSV

http://www.postgresql.org/docs/9.1/static/sql-copy.html

copy finance.timport

from '/home/bing/temp/201201x.csv'

with

csv

header

delimiter ','

quote '"'

;

There's an issue with the syntax in manual - 'format' keyword should not be there and is illegal, causes syntax error.