Andrej Ricnik-Bay wrote:
I'm currently mucking around w/ importing TAB-delimited files;
how can I import empty values into a double precision field?
COPY complains about nothing between the TABS, about "\N"
and other variations, as being
"invalid input syntax for type double precision:"
For best help it would be good to include your copy statement. As a guess, I'd
say you need to include the following in the statement...
NULL ''
--
Walter
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend