Thread: Syntax Error Inserting From STDIN?
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 What am I doing wrong? I am on 8.1.1... The table is defined as: --------------+------------------------+------------------------------------ ---------------------- id | integer | not null default issue_id | integer | title | character varying(255) | description | character varying(255) | feature_type | character varying(255) | Thx.
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.
Interesting. How would I go about solving that? I inserted an extra line between the two, no dice. > From: Scott Marlowe <smarlowe@g2switchworks.com> > Date: Tue, 20 Dec 2005 13:53:37 -0600 > To: Hunter's Lists <lists@lastonepicked.com> > Cc: PostgreSQL <pgsql-general@postgresql.org> > 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.
"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
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@g2switchworks.com> > > Date: Tue, 20 Dec 2005 13:53:37 -0600 > > To: Hunter's Lists <lists@lastonepicked.com> > > Cc: PostgreSQL <pgsql-general@postgresql.org> > > 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. > >
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@g2switchworks.com> > Date: Tue, 20 Dec 2005 16:41:32 -0600 > To: Hunter's Lists <lists@lastonepicked.com> > Cc: PostgreSQL <pgsql-general@postgresql.org> > 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@g2switchworks.com> >>> Date: Tue, 20 Dec 2005 13:53:37 -0600 >>> To: Hunter's Lists <lists@lastonepicked.com> >>> Cc: PostgreSQL <pgsql-general@postgresql.org> >>> 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