Thank you for your comment about text and binary format. To use text, I
thought one will have to construct the insert sql statement on the fly,
which will incurs server parsing, syntax checking followed by
execution. With binary format, I can simply prepare a statement and
then update each binded parameter prior to execute the prepared
statement over each records.
Is there a way for me to prepare the insert statment and pass in text
instead of, say, double precision? I experimented with that the the
server reject the insert statement with "mismatched datatype" error.
Jeff