如何将CSV文件导入Postgres并跳过第一行(仅为列标题)。我尝试:\COPY products(sight, department) from 'coy.csv' with (FORMAT CSV);
添加 HEADER 行将计入第一行为列标题的情况。COPY products (sight,department) FROM 'coy.csv' CSV HEADER; http://www.postgresql.org/docs/current/static/sql-copy.html