Re: ERROR: invalid input syntax for integer: - Mailing list pgsql-novice

On 22/09/2011, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> I don't believe that \copy will default to assuming that the file is in
> csv format.  You probably need to add "format csv" or something similar
> to that command.

Thanks; for the benefit of others, import was successful when the
above \copy command was appended with:

csv

When the csv file had no header columns.