Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nswM9-00040h-If for pgsql-admin@arkaria.postgresql.org; Mon, 23 May 2022 00:55:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nswM6-0002hc-Nq for pgsql-admin@arkaria.postgresql.org; Mon, 23 May 2022 00:55:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nswM6-0002gx-BX for pgsql-admin@lists.postgresql.org; Mon, 23 May 2022 00:55:30 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nswM1-0007z5-V7 for pgsql-admin@lists.postgresql.org; Mon, 23 May 2022 00:55:29 +0000 Received: by mail-ed1-x533.google.com with SMTP id c12so17176623eds.10 for ; Sun, 22 May 2022 17:55:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=GGLLGQJrpG1TFi8xd8EkvbuOqZ8QmUx0HE1VlGQ5ti4=; b=T+5mwIAEzlfeeq5pOmCNPP+pg1F1xLWoNkZ7MRMtMZ1F5aJA6tr6kpT78Zc12XpTFK tmdA3OS8fbam+wAPJ7MRlZoT9xnKIZFuA4Pu38DFVaB29D3x/JPF0H+wgh1CMM72LAOc RdyNt+uFlDCNNijGF/6Q0Kdyc2aUQp3AVs+fMXcCKnAnn6opjbTSXzRJAbzB6jPQ0I98 1Ucj88bNOEJjrpcbD32ZugBwSxzennL7dYHZCIeJ2mTwLj+EsX3HFmZmzMpqeD42F3kp F7rHM9h/Syl7MRMR0JTuHCC5JxIAGbE40n7ghr8emN0FtvhiK4SkEupuYpeCgC3zr3qD x5ng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=GGLLGQJrpG1TFi8xd8EkvbuOqZ8QmUx0HE1VlGQ5ti4=; b=j/yis7CGYDaPt02eiEuUIVpV/OZhEgPsSCHaaQ5dWZMNOh1qK7ogEJzkWVe3L96NY7 By1OxRQUmYt/1Z8S/orUif7rNue10BLHQZ4wNxrMKcVlwnj6T9VT0CPLPP2ncMWIwIEr fqijy/njag7CAHMvRtSlAuSz0Bsy40ivt0gtoH3nRxvwSMwxGTPvHKjQpAOqQixIEbkd KwxoaGn3QikwgvPwozaPPX6KKQcOPyE8Q3fuNWLYqqn5Of/XrM68sqe1ZjmJIcI/uGg6 fsXs/thRYyTHnVM8nmE2ziu9iYkFe3PijLtrqf5MYy0c7UkFBactk+YKlrEbxRoK3YEC qPtA== X-Gm-Message-State: AOAM532j3EurwA+8qJ9PzxGKQZNCrFQlFgwoiBXU/vtDeRjT/5Ys2kh0 Pcu60cjHcWVZr+QErqxGMpyL4vWBoBBgUJ0mHj0= X-Google-Smtp-Source: ABdhPJyumR8MvJdcBw2n+72X/bkBbDxeMEp+Oo7pFxFe3dg1kjMB9aaJWk9lRHX1AyoTDAchNn1oOtyvgy0gRWqe2n0= X-Received: by 2002:a50:d7cc:0:b0:42b:4d05:ac4a with SMTP id m12-20020a50d7cc000000b0042b4d05ac4amr7871620edj.294.1653267323709; Sun, 22 May 2022 17:55:23 -0700 (PDT) MIME-Version: 1.0 References: <01000180edd92947-49869ec0-ee04-41dd-89cf-fa2149676135-000000@email.amazonses.com> In-Reply-To: <01000180edd92947-49869ec0-ee04-41dd-89cf-fa2149676135-000000@email.amazonses.com> From: Devendra Postgres Date: Mon, 23 May 2022 06:25:18 +0530 Message-ID: Subject: Re: Need doc for PostgreSQL RDS External Table To: Doug Reynolds Cc: Scott Ribe , pgsql-admin Content-Type: multipart/alternative; boundary="0000000000008c6bf405dfa34bf2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008c6bf405dfa34bf2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you Doug, Will contact AWS Support. Cheers, On Mon, May 23, 2022 at 3:47 AM Doug Reynolds wrote: > AWS RDS for PostgreSQL has an extension to read/write from S3. > > > https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3= Import.html > > Contact your AWS TAM if you need help with the AWS specific module. > > On May 22, 2022, at 3:25 PM, Scott Ribe > wrote: > > =EF=BB=BF > > 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=E2=80=99t 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.S3= Import.html > > > > > --0000000000008c6bf405dfa34bf2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thank you Doug, Will contact AWS Support.=C2=A0

Cheers,

On Mon, May 23, 2022 at 3:47 AM Doug Reynolds <mav@wastegate.net> wrote:
AWS RD= S for PostgreSQL has an extension to read/write from S3. =C2=A0

Contact your AWS TAM if you need help with the AWS specific mod= ule.

On May 22, 20= 22, at 3:25 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:

=EF=BB=BFOn May 22, 2022, at 12:57 PM, Devendra Postgres <= ;devendr= apostgresdba@gmail.com> wrote:

R= equirement: 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=E2=80=99t load into the table(Postgr= es RDS).
Pls share any customized scri= pt/ doc what ever possible.

I= f you are going to use RDS, you will be limited to what Amazon provides--me= aning you will have to load the data into a table:
<= br>https://docs.aws.amazon.co= m/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html




--0000000000008c6bf405dfa34bf2--