var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Bug in Copy command??!
I'm using the copy command to fill my tables. I've got this file with the data with delimiter '\t' and 'isnull' for nulls as follows:
copy mytable FROM '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull';
But I receive an error saying that 'the value is too long for type varying(1)' This because I am filling a column defined as numeric(1) with nulls. Or in other cases I get a 'bad numeric input'
But if I insert some values into the table with 'insert', including nulls and then do
copy mytable TO '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull';
the file looks exactly the same as my original one!!How do I insert nulls into a numeric field with the copy command??
Am i missing something??