From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
---|---|
To: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Possible options to import xml files from desktop to postgress/AWS-RDS |
Date: | 2022-12-22 21:17:58 |
Message-ID: | CAAo1mbkUU5KEFfEaakDv0Ft633VCnii-YrpoB+VPgW=eb_WboQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)outlook(dot)com> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | M Sarwar | 2022-12-22 21:44:46 | Re: Possible options to import xml files from desktop to postgress/AWS-RDS |
Previous Message | M Sarwar | 2022-12-22 21:00:56 | Possible options to import xml files from desktop to postgress/AWS-RDS |