COPY error
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
On Mon, Jun 04, 2007 at 02:12:00PM -0400, ABHANG RANE wrote:
Im trying to load data from a file using copy command. At the end of
the data, I have appended copy statement ascopy tablename(col1, col2) from stdin with delimiter as '\t';
.\
COPY should go before the data and end-of-data (\. not .\) should
go after the data. Also, in text mode the default delimiter is the
tab character (\t) so you can omit it unless you prefer to be
explicit. Try something like this (with a tab after 2713):
copy tablename (col1, col2) from stdin;
2713 {3.70952,1.45728,0.134339,3.99197,2.22381,-0.435095,6.9}
\.
--
Michael Fuhr