Thank you Doug, Will contact AWS Support.
Cheers,
On Mon, May 23, 2022 at 3:47 AM Doug Reynolds <mav@xxxxxxxxxxxxx> wrote:
AWS RDS for PostgreSQL has an extension to read/write from S3.Contact your AWS TAM if you need help with the AWS specific module.On May 22, 2022, at 3:25 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:On May 22, 2022, at 12:57 PM, Devendra Postgres <devendrapostgresdba@xxxxxxxxx> wrote:Requirement: My CSV and flat files were there on the S3, and wanted to read the data which Iocated in S3 from the Postgres RDS table.Note: Data shouldn’t load into the table(Postgres RDS).Pls share any customized script/ doc what ever possible.
If you are going to use RDS, you will be limited to what Amazon provides--meaning you will have to load the data into a table:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html
