Postgres Data Dump problem
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