public inbox for [email protected]
help / color / mirror / Atom feedFrom: Devendra Postgres <[email protected]>
To: [email protected]
Subject: Re:Need doc for PostgreSQL RDS External Table
Date: Sun, 22 May 2022 19:43:47 +0530
Message-ID: <CAL1PVBaEKR+mWuusxA0w=B-ALo-shzjugNSZJPpXAwJ7M=N-AQ@mail.gmail.com> (raw)
In-Reply-To: <CAN0SRDFNZ1ht1OHmr=h55S60fn+5c7BC9YSUcYkHA+svhwKXig@mail.gmail.com>
References: <CAN0SRDFydu12pW+XV9KanakZwd9psbg9jA+7fMJuUDiB7iENQA@mail.gmail.com>
<[email protected]>
<CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>
<[email protected]>
<CAN0SRDFNZ1ht1OHmr=h55S60fn+5c7BC9YSUcYkHA+svhwKXig@mail.gmail.com>
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’t 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
view thread (14+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re:Need doc for PostgreSQL RDS External Table
In-Reply-To: <CAL1PVBaEKR+mWuusxA0w=B-ALo-shzjugNSZJPpXAwJ7M=N-AQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox