Home > mailing lists

Thread: Two different database in RDS access table.

Two different database in RDS access table.

From

qazi saif hussain

Date:

23 February, 16:50:01

Hi ,

I have two different databases in RDS Postgresql . Instance -A & Instance-B.Can someone give solution or work around .

(1) access table Instance -A TO Instance-B

(2) Marge table Instance -A & Instance-B .

Re: Two different database in RDS access table.

From

Licio Matos

Date:

23 February, 16:53:45

Hi,

you can use the extension postgres_fdw

https://aws.amazon.com/blogs/database/federated-query-support-for-amazon-aurora-postgresql-and-amazon-rds-for-postgresql/

Licio Matos

Em sex., 23 de fev. de 2024 às 10:50, qazi saif hussain <faiz.qazi0532@gmail.com> escreveu:

Hi ,
I have two different databases in RDS Postgresql . Instance -A & Instance-B.Can someone give solution or work around .
(1) access table Instance -A TO Instance-B
(2) Marge table Instance -A & Instance-B .