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.
Best regards.
Samed YILDIRIM
On Thu, 22 Dec 2022 at 23:01, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
Hello All,I need to upload the xml files data which are on my desktop or AWS-S3 data into Postgres which is running on AWS RDS.Hopefully, someone had situation in the past.Can you please share your experience or thoughts on this?
Thanks a lot,Sarwar
