Re: Syntax Error Inserting From STDIN?

Interesting.

How would I go about solving that?

I inserted an extra line between the two, no dice.

> From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
> Date: Tue, 20 Dec 2005 13:53:37 -0600
> To: Hunter's Lists <lists(at)lastonepicked(dot)com>
> Cc: PostgreSQL <pgsql-general(at)postgresql(dot)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.