MIME-Version: 1.0
References: 
 <CAN0SRDFydu12pW+XV9KanakZwd9psbg9jA+7fMJuUDiB7iENQA@mail.gmail.com>
 <D98D51ED-1786-4D12-AB46-D16F459AD6F4@gmail.com>
 <CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>
 <50d43222-8249-f7a8-ecca-7c696c4f5539@jakobs.com>
 <CAN0SRDFNZ1ht1OHmr=h55S60fn+5c7BC9YSUcYkHA+svhwKXig@mail.gmail.com>
In-Reply-To: 
 <CAN0SRDFNZ1ht1OHmr=h55S60fn+5c7BC9YSUcYkHA+svhwKXig@mail.gmail.com>
From: Devendra Postgres <devendrapostgresdba@gmail.com>
Date: Sun, 22 May 2022 19:43:47 +0530
Message-ID: 
 <CAL1PVBaEKR+mWuusxA0w=B-ALo-shzjugNSZJPpXAwJ7M=N-AQ@mail.gmail.com>
Subject: Re:Need doc for PostgreSQL RDS External Table
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b51b8a05df9a5591"
Archived-At: 
 <https://www.postgresql.org/message-id/CAL1PVBaEKR%2BmWuusxA0w%3DB-ALo-shzjugNSZJPpXAwJ7M%3DN-AQ%40mail.gmail.com>
Precedence: bulk

--000000000000b51b8a05df9a5591
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Good Morning & Good Evening All,

 As Migration, I need to convert one table from Oracle (Source) to
Postgres(Target)
The Oracle Table is created as below:

The oracle table is external table. What is external table : We will keep
 files(CSV/ flat files) in drive, we will create a one physical table in
oracle and when we select * from table, The oracle external table will go
to the CSV/Flat file and it will pull the data from the table and will
share results to the user.

FYI : it won=E2=80=99t store any physical data in the oracle database.

Requirement : we need similar kind of external concept in POSTGRESQL RDS.
The data ( CSV/Flat) is storing in S3 Bucket.

Could some one share doc/ URL .

Thxs,
Deva

--000000000000b51b8a05df9a5591
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Good Morning &amp; Good Evening All,</div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">=C2=A0As Migration, I need to convert one ta=
ble from Oracle (Source) to Postgres(Target)</div><div dir=3D"auto">The Ora=
cle Table is created as below:=C2=A0</div><div dir=3D"auto"><br></div><div =
dir=3D"auto">The oracle table is external table. What is external table : W=
e will keep =C2=A0files(CSV/ flat files) in drive, we will create a one phy=
sical table in oracle and when we select * from table, The oracle external =
table will go to the CSV/Flat file and it will pull the data from=C2=A0the =
table and will share results to the user.=C2=A0</div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">FYI : it won=E2=80=99t store any physical data in t=
he oracle database.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Requ=
irement : we need similar kind of external concept in POSTGRESQL RDS. The d=
ata ( CSV/Flat) is storing in S3 Bucket.</div><div dir=3D"auto"><br></div><=
div dir=3D"auto">Could some one share doc/ URL .</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">Thxs,</div><div dir=3D"auto">Deva</div><div dir=3D=
"auto"><br></div>

--000000000000b51b8a05df9a5591--