COPY error

From: ABHANG RANE <arane(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY error
Date: 2007-06-04 18:12:00
Message-ID: 20070604141200.axbl8xar2uck40gc@webmail.iu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Im trying to load data from a file using copy command. At the end of
the data, I have appended copy statement as

copy tablename(col1, col2) from stdin with delimiter as '\t';
.\

But I get following error.
ERROR: syntax error at or near "2713"
LINE 1: 2713 {3.70952,1.45728,0.134339,3.99197,2.22381,-0.435095,6.9...
^
invalid command \.

Thanks
Abhang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2007-06-04 18:15:18 Re: Moving pg_xlog to another drive
Previous Message Alvaro Herrera 2007-06-04 18:10:34 Re: Moving pg_xlog to another drive