Postgres Pro
Downloads
Home   >   mailing lists

COPY from and NULL values for double precisions fields - Mailing list pgsql-general

From Andrej Ricnik-Bay
Subject COPY from and NULL values for double precisions fields
Date
Msg-id b35603930703041808g440d797pbb20defe2480e0f0@mail.gmail.com
Whole thread Raw
Responses Re: COPY from and NULL values for double precisions fields  (Walter Vaughan <wvaughan@steelerubber.com>)
List pgsql-general
Tree view 
Hi Guys,

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:"

What *is* valid syntax for this?  Can't find it for the life of me.


Cheers,
Andrej

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Cannot digest subscribe
Next
From: Walter Vaughan
Date:
Subject: Re: COPY from and NULL values for double precisions fields