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

Reply via email to