[MonetDB-users] Load of null fields with COPY command.
On Fri, Dec 15, 2006 at 12:33:17PM +0100, JLP00993@correo.aeat.es wrote:
Hello again!
I have another question about data load.
How can I load null fields into a table with COPY command?.
For example, if I have the next row ...
123;Load test;;;;New field;0
... with fields separated by ';'.
Now, I have got next error message:
ERROR = !ERROR: decimal wrong format
for decimal fields and varchar fields are loaded as empty string ("") instead of null.
Simply add NULL instead of the empty strings should do the trick.
Niels
Thanks in advance!
Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
JLP00993@correo.aeat.es
-
Niels Nes