Syntax Error Inserting From STDIN? 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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings |