| From: | Devendra Postgres <devendrapostgresdba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re:Need doc for PostgreSQL RDS External Table |
| Date: | 2022-05-22 14:13:47 |
| Message-ID: | CAL1PVBaEKR+mWuusxA0w=B-ALo-shzjugNSZJPpXAwJ7M=N-AQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2022-05-22 14:53:38 | Re: Need doc for PostgreSQL RDS External Table |
| Previous Message | aditya desai | 2022-05-22 08:09:26 | Re: Steps to Install archived Postgres 9.3 and 9.6 |