Interesting.

How would I go about solving that?

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

> From: Scott Marlowe <[EMAIL PROTECTED]>
> Date: Tue, 20 Dec 2005 13:53:37 -0600
> To: Hunter's Lists <[EMAIL PROTECTED]>
> 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 5: don't forget to increase your free space map settings

Reply via email to