I am getting XML files which are generated by Oracle Reports.
I need to store them in the columns of Postgress tables which are xml data type. I need to do this because I will be using xmldata queries to populate the same table in the PostreSql.
I have backend programming experience with some exposure to front end programming experience as well.
From: Samed YILDIRIM <samed@reddoc.net> Sent: Thursday, December 22, 2022 4:17 PM To: M Sarwar <sarwarmd02@outlook.com> Cc: pgsql-admin <pgsql-admin@postgresql.org> Subject: Re: Possible options to import xml files from desktop to postgress/AWS-RDS
Hello Sarwar,
What is the structure of your XML files?
In which way do you want to store them in PostgreSQL?
Do you have any programming experience?
....
There are countless ways to import xml files into PostgreSQL. For example, if you want to keep them as a file, you can store them on a ByteA column or as a large object. Or, if you prefer to keep them as text, you can store them on a text column.
Do you need to parse an XML file and populate the data into a table? You can write a script to parse it and insert into the target table. Or, you can use xml functions of PostgreSQL to parse them by feeding the content of your XML file and directly store their outputs. I can't mention all possibilities here. :) I'm putting some links below. RDS for PostgreSQL has a special extension to access files in S3 buckets. It doesn't support XML. But, it can be useful to fetch data from S3 to feed XML functions in PostgreSQL.
