Re: Possible options to import xml files from desktop to postgress/AWS-RDS

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

 

Hello Samed,

1. I am getting XML files which are generated by Oracle Reports.
2. 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.
3. I have backend programming experience with some exposure to front end programming experience as well.
4. Yes, our data is primarily going to come thru S3 bucket. I need to explore S3 options as well.

Thanks a lot!

Sarwar

---

From: Samed YILDIRIM <samed@xxxxxxxxxx>
Sent: Thursday, December 22, 2022 4:17 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
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.

https://www.postgresql.org/docs/15/xml2.html

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html

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