| From: | Doug Reynolds <mav(at)wastegate(dot)net> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | Devendra Postgres <devendrapostgresdba(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need doc for PostgreSQL RDS External Table |
| Date: | 2022-05-22 22:17:53 |
| Message-ID: | 01000180edd92947-49869ec0-ee04-41dd-89cf-fa2149676135-000000@email.amazonses.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)elevated-dev(dot)com> wrote:
>
>
>>
>> On May 22, 2022, at 12:57 PM, Devendra Postgres <devendrapostgresdba(at)gmail(dot)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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devendra Postgres | 2022-05-23 00:55:18 | Re: Need doc for PostgreSQL RDS External Table |
| Previous Message | Scott Ribe | 2022-05-22 19:25:26 | Re: Need doc for PostgreSQL RDS External Table |