On 26 Nov 2002 at 15:20, Savita wrote:
> I would like to know if some field is not present in Text file,then how does
> COPY command handle it ,specially for date field.
I am not very sure about this, but one thing you can always do is to insert a
blank field separator, making copy believe that the field value is NULL.. Some
sed/awk script should do the trick..
HTH
Bye
Shridhar
--
"We all know Linux is great...it does infinite loops in 5 seconds."(Linus
Torvalds about the superiority of Linux on the AmterdamLinux Symposium)