dbadmin=> create table test (c float);
CREATE TABLE
dbadmin=> copy test from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 1.2
>> NaN
>> \.
dbadmin=> select * from test;
c
-----
1.2
NaN
(2 rows)

What error are you getting?

Jim Knicely

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.