Postgres Data Dump problem

Question

I am trying to dump this data into Postgres:

COPY address_types (game_id, device_type) FROM stdin;
1   Ps3
2   Xbox
3   Other
\.   

But I always get this error:

[Err] ERROR:  syntax error at or near "1"
LINE 2: 1 Ps3
        ^

Any ideas what might be wrong?

Answer 1

According to the PostgreSQL documentation on the COPY command the values must be separated by the delimiter character which is by default a tab (\t). If spaces are used instead I get a similar error on PostgreSQL 9.5. BTW: Which version do you use?

Alternatively you might try to alter the delimiter character:

nd1=> COPY address_types (game_id, device_type) FROM stdin with delimiter '#';
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 1#Ps3
>> 2#Xbox
>> 3#Other
>> \.
COPY 3