[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Need doc for PostgreSQL RDS External Table
From:       Devendra Postgres <devendrapostgresdba () gmail ! com>
Date:       2022-05-23 0:54:31
Message-ID: CAL1PVBZx=PTrm0xMTbDieLShcau2R=bMrphXssqq8FAFkGyTUA () mail ! gmail ! com
[Download RAW message or body]

Thank you Doug, Will contact AWS Support.

Cheers,

On Mon, May 23, 2022 at 3:47 AM Doug Reynolds <mav@wastegate.net> wrote:

> 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@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
>
>
>
>
>

[Attachment #3 (text/html)]

<div dir="ltr">Thank you Doug, Will contact AWS Support.  \
<div><br></div><div>Cheers,</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, May 23, 2022 at 3:47 AM Doug Reynolds &lt;<a \
href="mailto:mav@wastegate.net">mav@wastegate.net</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="auto">AWS RDS for PostgreSQL has an \
extension to read/write from S3.   <div><br></div><div><a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html" \
target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html</a></div><div><br></div><div>Contact \
your AWS TAM if you need help with the AWS specific module.</div><div><div \
dir="ltr"><br><blockquote type="cite">On May 22, 2022, at 3:25 PM, Scott Ribe &lt;<a \
href="mailto:scott_ribe@elevated-dev.com" \
target="_blank">scott_ribe@elevated-dev.com</a>&gt; \
wrote:<br><br></blockquote></div><blockquote type="cite"><div \
dir="ltr"><blockquote type="cite"><span>On May 22, 2022, at 12:57 PM, Devendra \
Postgres &lt;<a href="mailto:devendrapostgresdba@gmail.com" \
target="_blank">devendrapostgresdba@gmail.com</a>&gt; \
wrote:</span><br></blockquote><blockquote \
type="cite"><span></span><br></blockquote><blockquote type="cite"><span>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. </span><br></blockquote><blockquote \
type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Note: Data \
shouldn't load into the table(Postgres RDS). </span><br></blockquote><blockquote \
type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Pls share any \
customized script/ doc what ever \
possible.</span><br></blockquote><span></span><br><span>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:</span><br><span></span><br><span><a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html" \
target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL \
.S3Import.html</a></span><br><span></span><br><span></span><br><span></span><br><span></span><br></div></blockquote></div></div></blockquote></div>




[prev in list] [next in list] [prev in thread] [next in thread]