Perhaps you can run your file through a filter to replace '' to null.
Any of sed, perl, python and other scripting languages would do nicely.
e.g.
sed -e "s/''/null/g" < myfile > myfile2
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Maurizio Ortolan
Sent: Thursday, March 29, 2001 6:50 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [SQL] Error in the date field (with NULL value...).Thanks!
...
My question:
How can I resolv my problem? I have a big data file to import where
in the 2nd date field there is '' instead of null ....
How can I "binds" PostgreSQL to consider '' as null ?
Many thanks for any suggestions!
CIAO!
MAURIZIO
*******************************************
** Happy surfing on THE NET !! **
** Ciao by **
** C R I X 98 **
*******************************************
AntiSpam: rimuovere il trattino basso
dall'indirizzo per scrivermi...
(delete the underscore from the e-mail address to reply)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
