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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
