Re: Syntax Error Inserting From STDIN? - Mailing list pgsql-general

From Tom Lane
Subject Re: Syntax Error Inserting From STDIN?
Date
Msg-id 6606.1135115354@sss.pgh.pa.us
Whole thread Raw
In response to Syntax Error Inserting From STDIN?  (Hunter's Lists <lists@lastonepicked.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Hunter's Lists
Date:
Subject: Re: Syntax Error Inserting From STDIN?
Next
From: Scott Marlowe
Date:
Subject: Re: Syntax Error Inserting From STDIN?