[radiowave]

Never tried this with RDS, but it's entirely possible to use postgres_fdw to interact with a foreign table on another postgres server, where you might have more choice about what extensions you run.

I'm doing this right now because I have a postgres installation that it's not yet convenient to upgrade beyond v12, but where I'd really like the benefit of the recently-improved JDBC FDW, which requires at least v13.

[intrasight]

I am very interested in this idea. Has anyone used postgres_fwd in RDS to connect to their own postgres instance where they run custom extensions?