UsergeJeoff
New Member
I am a beginner in SQL and need to answer the following question.I have thousands of XML files (each has hundreds of nodes) and need to build a Postgresql database above the data inside them. I consider two ways:[*]to convert XML files into one (or more) large database table (one XML node = one line in SQL table) and work with this table.[*]to create a database with native XML type (store XML type data inside database) and for searching and filtering use XPath... Which approach could be better (faster, more comfortable)? What are the advantages and disadvantages of using XML type inside SQL database?