View Single Post

   
  #4 (permalink)  
Old 04-09-2008, 07:33 AM
Tom Lane
 
Posts: n/a
Default Re: Syntax Error Inserting From STDIN?

"Hunter's Lists" <lists@lastonepicked.com> writes:
> I get back:


> COPY departments (id, issue_id, title, description, feature_type) FROM
> stdin;


> 23 4 Local Buzz Things to do, people to see, places to go. aspen


> ERROR: syntax error at or near "23" at character 80


How are you feeding this into Postgres exactly? Scott's right that it
looks like the connection isn't getting switched into COPY mode at the
right instant, but you haven't given us any hint about why that might
be happening.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote