public inbox for [email protected]
help / color / mirror / Atom feedFrom: Devendra Postgres <[email protected]>
To: Mladen Gogala <[email protected]>
Cc: [email protected]
Subject: Re: Need doc for PostgreSQL RDS External Table
Date: Mon, 23 May 2022 00:27:48 +0530
Message-ID: <CAL1PVBaPxppU79ZXUBnGJgqjtRo3eBjQ-eqgEb1-j+q3njLZpQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
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>
<CAL1PVBaEKR+mWuusxA0w=B-ALo-shzjugNSZJPpXAwJ7M=N-AQ@mail.gmail.com>
<[email protected]>
<CAL1PVBa=sYb51ObgLA+gF8_B=t9O9q5QDVtKaSLZL8cdorSa0Q@mail.gmail.com>
<[email protected]>
Thxs Mladen for quick info.
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.
Thxs
On Mon, 23 May 2022 at 12:18 AM, Mladen Gogala <[email protected]>
wrote:
> On 5/22/22 12:06, Devendra Postgres wrote:
>
> Thanks Mladen,
>
> Getting this error, when tried to create extension in AWS RDS .
>
> postgres=> create extension file_fdw;
> ERROR: Extension "file_fdw" is not supported by Amazon RDS
> DETAIL: Installing the extension "file_fdw" failed, because it is not on
> the list of extensions supported by Amazon RDS.
> HINT: Amazon RDS allows users with rds_superuser role to install
> supported extensions. See: SHOW rds.extensions;
> postgres=>
>
> On Sun, May 22, 2022 at 8:23 PM Mladen Gogala <[email protected]>
> wrote:
>
>> On 5/22/22 10:13, Devendra Postgres wrote:
>>
>> 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
>>
>> Deva, RDS is DaaS (Database as a disService). You don't get access to the
> underlying OS. There are certain admin functions which are described in the
> manual, but they don't give you access to anything else except pg_hba.conf
> and postgresql.conf. You will have to load CSV files from your local psql
> using \copy command or a custom script, preferably using DBD::Pg. And
> remember, always use strict.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>
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], [email protected]
Subject: Re: Need doc for PostgreSQL RDS External Table
In-Reply-To: <CAL1PVBaPxppU79ZXUBnGJgqjtRo3eBjQ-eqgEb1-j+q3njLZpQ@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