Re:Open-Source Babelfish for Postgres
by Conan_Kudo on Thursday October 28, 2021 @08:57PM
(#29034031)
PostgreSQL already supports Oracle DB dialect and protocol, I thought?
[ Parent
| on HN ]
postgres takes a lot of design inspiration from Oracle, but AFAIK has never made any real attempt at being strictly compatible with it.
You might be thinking of dblink in oracle's world, and foreign data wrapper (fdw) in postgres, which at least lets you transparently interact between the two for just DQL. DDL, procedural logic, etc definitely differs.
There's also EnterpriseDB, a commercial version of PostgreSQL that has added support for the Oracle SQL dialect, including the stored proc language (pl/SQL or whatever it's called).
I don't think it speaks the Oracle wire protocol though.