Does Azure cosmos DB for Postgresql support oracle_fdw extension?

Question

Can you please confirm if Azure Cosmos DB for Postgresql provides oracle_fdw extension to enable creating foreign tables in Postgresql that connects to the Oracle tables or schemas?

I know it's been mentioned that oracle_fdw is available for Azure Postgresql Flexible Server but I'm not sure if the same is available in Azure Cosmos DB for PG.

Answer 1

@Nick Chuah
Thank you for the question and for using Microsoft Q&A platform.

Azure Cosmos DB for PostgreSQL does not currently support the oracle_fdw extension. This extension is available for Azure Database for PostgreSQL - Flexible Server, which allows you to create foreign tables in PostgreSQL that connect to Oracle tables or schemas.
https://techcommunity.microsoft.com/blog/adforpostgresql/introducing-support-for-oracle-fdw-extension-in-azure-database-for-postgresql/4296504

The available extensions for Azure Cosmos DB are listed here:
https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/reference-extensions

If you need to use the oracle_fdw extension, you should consider using Azure Database for PostgreSQL - Flexible Server instead of Azure Cosmos DB for PostgreSQL.

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.