View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 07:32 AM
Hunter's Lists
 
Posts: n/a
Default 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

Reply With Quote