Interesting. How would I go about solving that? I inserted an extra line between the two, no dice. > From: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> > Date: Tue, 20 Dec 2005 13:53:37 -0600 > To: Hunter's Lists <lists@xxxxxxxxxxxxxxxxx> > Cc: PostgreSQL <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: [GENERAL] Syntax Error Inserting From STDIN? > > 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.
