Syntax Error Inserting From STDIN?

From: Hunter's Lists <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Syntax Error Inserting From STDIN?
Date: 2005-12-20 19:30:34
Message-ID: BFCD9BDA.AF60B%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

What am I doing wrong? I am on 8.1.1...

The table is defined as:

--------------+------------------------+------------------------------------
----------------------
id | integer | not null default
issue_id | integer |
title | character varying(255) |
description | character varying(255) |
feature_type | character varying(255) |

Thx.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-12-20 19:53:37 Re: Syntax Error Inserting From STDIN?
Previous Message Jim C. Nasby 2005-12-20 18:25:55 Re: recursive function