Hi...
Postgres 7.3
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.
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.
Am i missing something??
thanks!
Carla
This e-mail and any attachment is for authorised use by the intended recipient(s)
only. It may contain proprietary material, confidential information and/or be subject
to legal privilege. It should not be copied, disclosed to, retained or used by, any
other party. If you are not an intended recipient then please promptly delete this
e-mail and any attachment and all copies and inform the sender. Thank you.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
