Can prisma now work with Postgres FDW??
At my company the bosses are reluctant to migrate to postgres, so they stay at sqlserver 12....
One alternative would be using the foreign data wrappers to access and serve the sqlserver via postgres....
Can prisma now work with it correctly? The site says that it is a supported extension...
1 Reply
You chose to compile with the bot. One moment while I piece together your answer…
Prisma does not currently have full support for working with PostgreSQL Foreign Data Wrappers (FDW), including
postgres_fdw. While the postgres_fdw extension is listed as supported, this means you can use the extension in your database, but Prisma cannot introspect or generate models for foreign tables created via FDW. Multiple open issues confirm that Prisma cannot introspect foreign tables, and attempts to do so will not work as expected—foreign tables are ignored during introspection, and migration scripts may fail or not behave as intended. There is ongoing discussion and feature requests for this capability, but it is not yet implemented [Support PostgreSQL postgres_fdw extension: Foreign Data Wrappers].
If your goal is to use Prisma to access SQL Server data via a Postgres FDW, this is not currently possible in a seamless or officially supported way. You would need to access the SQL Server database directly with Prisma (which is now supported for SQL Server 2017+), or use other tools for FDW access and handle the limitations manually [Supported databases].
In summary: Prisma does not yet support working with foreign tables via Postgres FDW. If this is a critical requirement, you may need to wait for future updates or consider alternative approaches.
✅ Great, thanks for letting us know that this solved your question!