Importing an xml schema into postgres to automatically create a table and then populate it with an xml file?

I have a huge xml file that I cannot open unless I import it into a database. I am using Postgres for this. I have a schema that goes with this data file. There are too many columns so i'd like to automate the process of creating a table from this schema and then importing the data file from the local drive on my computer to populate this table. How do i do this?

I saw a lot of answers on SO but haven't been able to understand this correctly. Also...

Read More »

By: StackOverFlow - Monday, 16 April

Related Posts