Postgres Data Dump problem 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?
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=&gt; 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.
&gt;&gt; 1#Ps3
&gt;&gt; 2#Xbox
&gt;&gt; 3#Other
&gt;&gt; \.
COPY 3