On Wed, Sep 21, 2011 at 4:04 PM, e-letter <inpost(at)gmail(dot)com> wrote:
> Using the command:
>
> \copy tablename from file.csv
>
> Causes the command terminal error:
>
> input syntax for integer: "123456,2000-01-01,01:10,"sometext""
> CONTEXT: COPY tablename, line 1, column column2: "123456
>
> What is my mistake please?
>
Within psql, the following works for me:
\COPY tablename FROM file.csv CSV HEADER