Search Postgresql Archives

Syntax Error Inserting From STDIN?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux