Everything was on OS X. Looks like it was a problem with spaces vs. tabs. Anyway, I went through and fixed all the lines and everything went in. We had a strange problem restoring a 8.0.4 dump to a 8.1.1 server and this was the last of the data that had to be re-imported. > From: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> > Date: Tue, 20 Dec 2005 16:41:32 -0600 > To: Hunter's Lists <lists@xxxxxxxxxxxxxxxxx> > Cc: PostgreSQL <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: [GENERAL] Syntax Error Inserting From STDIN? > > quick answer, try a different editor. > > Are you editing in the same environment as the database is in, or are > you editing on windows and feeding the copy data in on another platform? > > On Tue, 2005-12-20 at 14:40, Hunter's Lists wrote: >> 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. >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
