Search Postgresql Archives

Re: Syntax Error Inserting From STDIN?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Hunter's Lists" <lists@xxxxxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux