Instead of defining an xpath for fields define one that captures the xml pertaining to the data that would belong to a single record.How to create single xpath or xsl which assigns values to all columns in Postgres table ?
I havent found such sample. Samples which I have found create every column separately using separate xpath.
I don't know - I'm not a heavy user of xpath/xml. I do know that "text()" will not be of help because you have to return an entire node - xml elements included. The textual representation of that node is then to be stored and all the extraction xpath expression executed against it.
