Re: ERROR: invalid input syntax for integer:

From: e-letter <inpost(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: invalid input syntax for integer:
Date: 2011-09-22 21:27:22
Message-ID: CAET1fe6a+12f8fhFy73HAdUc_RAzQ9CJbVuxkXx48KZRgdTUwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 22/09/2011, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Arvind Sharma 2011-09-22 22:02:31 PG-9.0 - XML Data in a Column
Previous Message James Hartley 2011-09-22 00:33:41 Re: ERROR: invalid input syntax for integer: