Re: Need doc for PostgreSQL RDS External Table

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Sun, 22 May 2022 14:47:59 -0400



    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 <gogala.mladen@xxxxxxxxx>
          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-1217
https://dbwhisperer.wordpress.com