On Tue, 2005-12-20 at 13:30, Hunter's Lists wrote: > I am trying to run the following: > > 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 > > 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 Seeing that "character 80" I'm gonna guess this is a CR/LF issue. I.e. pgsql on your machine is seeing the 23 as being on the same line as the copy departments statement.
