AWS RDS for PostgreSQL has an extension to read/write from S3. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.htmlContact your AWS TAM if you need help with the AWS specific module.On May 22, 2022, at 3:25 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:On May 22, 2022, at 12:57 PM, Devendra Postgres <devendrapostgresdba@gmail.com> 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
On May 22, 2022, at 3:25 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On May 22, 2022, at 12:57 PM, Devendra Postgres <devendrapostgresdba@gmail.com> 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
On May 22, 2022, at 12:57 PM, Devendra Postgres <devendrapostgresdba@gmail.com> 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.
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных