Re: 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.