Re: Need doc for PostgreSQL RDS External Table

[Doug Reynolds <mav@xxxxxxxxxxxxx>]

AWS RDS for PostgreSQL has an extension to read/write from S3.  

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

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