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