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.