Thanks a lot. But I do got lot of challenges! Looks like SO data contains lot of tabs within itself.. So tabs delimiter didn't work for me. I thought I can give a special demiliter but looks like Postrgesql copy allow only one character as delimiter :(
Sad, I guess only way is to insert or do a through serialization of my data into something that COPY can understand.
easiest way would be:
xml -> csv -> \copy
by csv, I mean regular quoted csv (Simply wrap csv field with double quote, and escape
enventually contained quotes with an other double quote.).
I tried but no luck. Here is the sample csv, I wrote from my xml convertor: