On Saturday, August 27, 2011 10:03:53 pm planas wrote:
> Hi,
>
> I am attempting to import a csv file into a predefined, empty table
> using the following commands:
>
> COPY ContactUpdates
> FROM '/media/Fred/Work/SQL_Server/AP/ContactUpdates.csv'
> WITH DELIMITERS ',' CSV
>
> When testing the query I get the following error message
>
> ERROR: syntax error at or near "COPY"
> LINE 1: ...(ANALYZE off, VERBOSE off, COSTS on, BUFFERS off )COPY
> Conta...
> ^
>
>
> ********** Error **********
>
> ERROR: syntax error at or near "COPY"
> SQL state: 42601
> Character: 59
>
> I have been able to determine what the error is. Researching the
> question does not give me any clue what is wrong or what the syntax
> error is.
Is the above the only command being run? Where is this coming from?:
LINE 1: ...(ANALYZE off, VERBOSE off, COSTS on, BUFFERS off )...
>
> Using pgsql 9.1 rc1 on Ubuntu 11.04 (Gnome) 64 bit using pgadminIII
--
Adrian Klaver
adrian.klaver@gmail.com