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.

 

Thanks in advance!