Re: Syntax Error Inserting From STDIN?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hunter's Lists" <lists(at)lastonepicked(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Syntax Error Inserting From STDIN?
Date: 2005-12-20 21:49:14
Message-ID: 6606.1135115354@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Hunter's Lists" <lists(at)lastonepicked(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-12-20 22:41:32 Re: Syntax Error Inserting From STDIN?
Previous Message Alexander Scholz 2005-12-20 21:21:54 Newbie Question: FAQ for database optimization?