↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Foreign Data Wrappers

Foreign Data Wrappers

Compare versions

External data adapters, versioned capabilities, transaction behavior and extension evidence.

Reading PostgreSQL 18.6.

2 core entries; 2 recorded in PostgreSQL 18.6.

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

FDW-category catalogue

Current catalogue observation 2026-09-29 from pgext.universe. Extension versions, source metadata dates and declared PostgreSQL compatibility are independent of the selected core version. Catalogue classification does not establish capabilities or maintenance support.

148 directory rows.

Existing extensionCatalogued versionDeclared PG majorsMetadata checkedEvidence scopeCatalogued purpose
wrappers0.6.314, 15, 16, 17, 182026-08-30Wrapper frameworkForeign data wrappers developed by Supabase
multicorn3.214, 15, 16, 17, 182026-08-30Wrapper frameworkFetch foreign data in Python in your PostgreSQL server.
odbc_fdw0.5.214, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for accessing remote databases using ODBC
jdbc_fdw1.214, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for remote servers available over JDBC
pgspider_ext1.3.015, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for remote PGSpider servers
mysql_fdw2.9.314, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying a MySQL server
oracle_fdw2.9.014, 15, 16, 17, 182026-08-30Primary documentation reviewed separately belowforeign data wrapper for Oracle access
tds_fdw2.0.514, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdw18.2.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign data wrapper for DB2 access
sqlite_fdw2.5.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedSQLite Foreign Data Wrapper
pgbouncer_fdw1.4.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedExtension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
etcd_fdw0.0.114, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for etcd
informix_fdw0.6.314, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for Informix access
nominatim_fdw2.314, 15, 16, 17, 182026-09-29Catalogue candidate; interface unverifiedNominatim Foreign Data Wrapper for PostgreSQL
mongo_fdw5.5.314, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign data wrapper for MongoDB access
redis_fdw1.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying a Redis server
redis0.0.114, 15, 16, 17, 182026-08-30Related messaging interfaceSend redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw0.0.314, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedkafka Foreign Data Wrapper for CSV formatted messages
hdfs_fdw2.0.514, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for remote hdfs servers
firebird_fdw1.4.214, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for Firebird
rdf_fdw3.014, 15, 16, 17, 182026-09-27Catalogue candidate; interface unverifiedForeign data wrapper for RDF triplestores over SPARQL endpoints
aws_s30.0.114, 15, 16, 17, 182026-08-30Related import/export interfaceaws_s3 postgres extension to import/export data from/to s3
log_fdw1.514, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for Postgres log file access
dblink1.214, 15, 16, 17, 18Not recordedRelated remote-query interfaceconnect to other PostgreSQL databases from within a database
file_fdw1.014, 15, 16, 17, 18Not recordedCore interface; see versioned entryforeign-data wrapper for flat file access
postgres_fdw1.114, 15, 16, 17, 18Not recordedCore interface; see versioned entryforeign-data wrapper for remote PostgreSQL servers
clickhousedb_fdw111, 12, 132026-08-30Catalogue candidate; interface unverifiedClickHouse foreign data wrapper with SELECT/INSERT support plus aggregate and join pushdown.
holycorn1.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Wrapper frameworkRuby foreign data wrapper provider
json_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for local and remote JSON document access.
parquet_fdw0.210, 11, 12, 13, 14, 15, 162026-08-30Catalogue candidate; interface unverifiedRead-only foreign data wrapper for Apache Parquet files
www_fdw0.1.9Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for accessing web services from PostgreSQL.
dblink_plus1.0.11Unknown2026-08-30Related remote-query interfaceRun SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL.
cassandra2_fdw2.011, 12, 13, 14, 152026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying Cassandra 2.x and newer from PostgreSQL.
ch_fdw1.0132026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for federated access from PostgreSQL to ClickHouse.
couchdb_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying CouchDB from PostgreSQL.
dump_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying rows directly from PostgreSQL custom-format dump files
file_fixed_length_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for files with fixed-length fields.
file_textarray_fdw1.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper returning each text-file row as a text array.
git_fdw1.1.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedPostgreSQL Git Foreign Data Wrapper
go_fdw1.0Unknown2026-08-30Wrapper development frameworkExperimental Go/cgo project template for building PostgreSQL foreign data wrappers.
bigtable0.1.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedRust PostgreSQL FDW for Google Bigtable
griddb_fdw1.213, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedGridDB Foreign Data Wrapper for PostgreSQL
hello_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for hello world
influxdb_fdw1.313, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying InfluxDB from PostgreSQL.
jdbc2_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedExperimental foreign data wrapper for JDBC-accessible databases with remote filter pushdown.
kt_fdw0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading and writing Kyoto Tycoon key-value stores.
ldap_fdw0.1.1Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying LDAP servers
osm_fdw4.1.210, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading OpenStreetMap PBF files
kv_fdw0.0.1132026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for key-value storage backed by RocksDB/VidarDB.
quasar_fdw1.4.1Unknown2026-08-30Catalogue candidate; interface unverifiedquasar_fdw: push PostgreSQL queries down to Quasar-supported data backends
s3_fdw0.1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading Amazon S3 files through PostgreSQL COPY format.
twitter_fdw1.1.0Unknown2026-08-30Catalogue candidate; interface unverifiedLegacy foreign data wrapper for the retired unauthenticated Twitter Search API.
monetdb_fdw0.0Unknown2026-08-30Catalogue candidate; interface unverifiedMonetDB foreign data wrapper
neo4j-fdw4.3.2-dev10, 11, 122026-08-30Catalogue candidate; interface unverifiedMulticorn-based foreign data wrapper and Cypher functions for Neo4j.
neo4j_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedC foreign data wrapper for Neo4j Cypher query results.
orc_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading ORC formatted files
lsm0.111, 12, 132026-08-30Catalogue candidate; interface unverifiedRocksDB foreign data wrapper for PostgreSQL
oblivpg_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedOblivious foreign data wrapper for table access backed by trusted hardware and ORAM
kadb_fdw0.10.2Unknown2026-08-30Catalogue candidate; interface unverifiedTransactional Kafka foreign data wrapper for Arenadata DB and Greenplum
cassandra_fdw3.111, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for querying Cassandra 3+
db2odbc_fdw1.0122026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for accessing IBM Db2 through an ODBC data source
hive_fdw4.0132026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying Apache Hive from PostgreSQL.
lua_fdw0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedLua Foreign Data Wrapper
ocgeo_fdw1.010, 11, 12, 13, 142026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for the OpenCageData API
douban_fdw1.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying Douban public movie-ranking APIs
passwd-fdw0.4.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for Unix/Linux passwd and group databases.
aerospike_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign Data Wrapper for Aerospike.
file_fdw_program1.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedBackport of file_fdw PROGRAM support, exposing a file_fdw-like foreign data wrapper that reads from external commands.
greenplum_fdw1.012, 132026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying Greenplum from PostgreSQL using SERIALIZABLE remote transactions.
treasuredata_fdw1.210, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedC foreign data wrapper backed by a Rust td-client bridge for querying and inserting Treasure Data datasets.
tsf_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedGolden Helix C foreign data wrapper for reading one or more TSF genomic data files as PostgreSQL foreign tables.
tuple_fdw0.1Unknown2026-08-30Catalogue candidate; interface unverifiedProof-of-concept C foreign data wrapper for append-only, LZ4-compressed binary tuple files used as cold storage.
wdb_fdw0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedWhiteDB Foreign Data Wrapper
gtables_fdw0.1Unknown2026-08-30Catalogue candidate; interface unverifiedGlobal tables across FDW API
hash_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedShared-memory hash-table foreign data wrapper for storing and querying rows by a configured key.
hba_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedWork-in-progress foreign data wrapper scaffold intended to expose pg_hba.conf through SQL.
hbase_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying HBase from PostgreSQL.
pgc_fdw1.0122026-08-30Catalogue candidate; interface unverifiedAccess remote PostgreSQL tables through a postgres_fdw-derived wrapper with a FoundationDB-backed query cache
pglog1.0Unknown2026-08-30Catalogue candidate; interface unverifiedPostgreSQL log via SQL
postgres_fdw_plus1.016, 17, 182026-08-30Catalogue candidate; interface unverifiedFork postgres_fdw to coordinate remote PostgreSQL transactions with optional two-phase commit and recovery helpers
rasterdb0.1Unknown2026-08-30Catalogue candidate; interface unverifiedrasterdb: filesystem-backed PostGIS raster foreign data wrapper
sybase_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedC foreign data wrapper for accessing Sybase databases from PostgreSQL.
template_fdw0.010, 11, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for template tables that intentionally rejects SELECT and DML operations.
dataclips0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedArchived, unfinished C prototype for querying Heroku Dataclips through a function and planned FDW.
redis_link1.0162026-08-30Catalogue candidate; interface unverifiedRead-write PostgreSQL foreign data wrapper for Redis strings, hashes, and sets, with basic Redis Cluster support
clerk_fdw0.3.314, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying the Clerk user-management API from PostgreSQL.
prometheus_fdw0.2.114, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedA Rust/pgrx foreign data wrapper that queries Prometheus metrics through PostgreSQL foreign tables.
lance0.0.013, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedPostgreSQL FDW extension for reading and querying Lance format tables
pg_kalam0.5.5-rc.113, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedKalamDB PostgreSQL extension and FDW callback layer for SQL access to KalamDB.
orb_fdw0.13.314, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedA foreign data wrapper for Orb
db721_fdw0.0.011, 12, 13, 14, 152026-08-30Catalogue candidate; interface unverifiedRust/pgrx foreign data wrapper for db721 files, developed for CMU 15-721 project data.
prometheusfdw0.0.214, 15, 162026-08-30Catalogue candidate; interface unverifiedQueries Prometheus instant-vector data through a PostgreSQL foreign data wrapper.
ebs_fdw0.0.011, 12, 13, 14, 152026-08-30Catalogue candidate; interface unverifiedRust/pgrx foreign data wrapper for listing AWS EBS volumes through PostgreSQL.
clickhouse_fdw1.411, 12, 13, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedClickHouse foreign data wrapper for PostgreSQL
cos_fdw1.010, 11, 12, 13, 14, 15, 16, 17, 182026-07-11Catalogue candidate; interface unverifiedTencentDB PostgreSQL foreign data wrapper for reading CSV data from Tencent Cloud Object Storage (COS).
dynamodb_fdw1.113, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying and modifying Amazon DynamoDB tables from PostgreSQL.
external_search_fdwNot recorded17, 182026-07-11Catalogue candidate; interface unverifiedAlloyDB extension that provides a read-only foreign data wrapper for querying Elasticsearch data from PostgreSQL.
obs_fdw1.0.013, 14, 15, 16, 172026-07-12Catalogue candidate; interface unverifiedHuawei Cloud OBS foreign data wrapper extension listed for RDS PostgreSQL.
oss_fdwNot recorded11, 14, 162026-07-12Catalogue candidate; interface unverifiedAlibaba Cloud OSS foreign data wrapper for reading and writing OSS objects from PostgreSQL-compatible managed services.
parquet_s3_fdw0.313, 14, 15, 16, 172026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL.
scylla_fdw1.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying and modifying ScyllaDB tables from PostgreSQL over CQL.
starrocks_fdw1.213, 14, 15, 16, 17, 182026-07-13Catalogue candidate; interface unverifiedTencentDB for PostgreSQL foreign data wrapper for querying StarRocks tables through a MySQL-compatible interface.
steampipe_postgres_aws0.125.014, 152026-08-30Catalogue candidate; interface unverifiedSteampipe AWS native PostgreSQL FDW for querying live AWS APIs as foreign tables.
valkey_fdw1.017, 182026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for querying a Valkey server
vmagentfdw0.0.214, 15, 162026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading vmagent scrape-target status through its HTTP API.
redis_fdw_rs0.6.014, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedThis extension allows PostgreSQL to directly query and manipulate Redis data as if it were regular PostgreSQL tables.
pg_conn20.1Unknown2026-08-30Catalogue candidate; interface unverifiedManage separate PostgreSQL database connections from SQL code
pg_sheet_fdw0.1.213, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedRead local Excel XLSX worksheets as PostgreSQL foreign tables
oai_fdw1.1311, 12, 13, 14, 15, 16, 17, 182026-08-30Catalogue candidate; interface unverifiedOAI-PMH foreign data wrapper for PostgreSQL
multicdr_fdw1.2.2Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper for reading call-detail-record file streams as external SQL tables.
ansilo_pgx0.1.0Unknown2026-08-30Catalogue candidate; interface unverifiedA Postgres interface into any database
busybee_fdw0.1Unknown2026-07-27Catalogue candidate; interface unverifiedMQTT Foreign Data Wrapper
dir_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedforeign-data wrapper for readdir
dummy_data1.0Unknown2026-07-27Catalogue candidate; interface unverifiedReadable, Null Foreign Data Wrapper for Postgresql 9.3+
filesystem0.4.0Unknown2026-08-30Catalogue candidate; interface unverifiedfilesystem foreign data wrapper
gofdw0.1Unknown2026-08-30Catalogue candidate; interface unverifiedPostgres FDW in go experiments
gp_exttable_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedExternal Table Foreign Data Wrapper for Greenplum-family databases.
grpc_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedForeign data wrapper that delegates table operations to services over gRPC.
level_pivot1.0Unknown2026-08-30Catalogue candidate; interface unverifiedLevelDB FDW with support for pivoting and key templating
pg_kafka0.0.0Unknown2026-08-30Catalogue candidate; interface unverifiedKafka foreign data wrapper for PostgreSQL.
pg_monetdb1.4Unknown2026-08-30Catalogue candidate; interface unverifiedMonetDB foreign-data wrapper with stronger analytical pushdown
pgtokdb0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedPostgreSQL to kdb+ Extension
pxf1.0Unknown2026-08-30Catalogue candidate; interface unverifiedHistorical Greenplum extension for accessing unmanaged data through PXF.
pxf_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedPXF Framework for Greengage
r53db0.1Unknown2026-08-30Catalogue candidate; interface unverifiedr53db, the PostgreSQL Foreign Data Wrapper for the AWS Route53 Database service
steampipe_postgres_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedZero-ETL foreign data wrapper that maps PostgreSQL foreign tables to cloud-service and API calls.
tibero_fdw1.0Unknown2026-08-30Catalogue candidate; interface unverifiedPostgreSQL foreign data wrapper source code for Tibero
tsurugi_fdw1.5.0Unknown2026-08-30Catalogue candidate; interface unverifiedTsurugi Foreign Data Wrapper for PostgreSQL.
zipfile-fdw0.0.1Unknown2026-08-30Catalogue candidate; interface unverifiedPrototype foreign data wrapper scaffold for ZIP-file access.
dc_fdw1.09.1, 9.2, 9.32026-08-31Catalogue candidate; interface unverifiedHistorical foreign data wrapper for document collections stored on local disk.
openapi_fdw0.4.114, 15, 16, 17, 182026-08-31Catalogue candidate; interface unverifiedRead/write foreign data wrapper for OpenAPI and JSON HTTP services.
pgwrh_fdw1.0.0-alpha1182026-09-21Catalogue candidate; interface unverifiedPostgreSQL foreign data wrapper with transaction setting propagation and replica routing
gaia_fdw0.6Unknown2026-09-26Catalogue candidate; interface unverifiedForeign data wrapper for querying and modifying Gaia Platform databases
sdb_fdw1.09.32026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for SequoiaDB collections
dist_fdw1.0Unknown2026-09-29Catalogue candidate; interface unverifiedopenGauss foreign data wrapper for bulk loading external files
mot_fdw1.0Unknown2026-09-29Catalogue candidate; interface unverifiedopenGauss memory-optimized table engine FDW adapter
yesno_pg0.1.017, 182026-09-29Catalogue candidate; interface unverifiedyesnodb foreign data, index and table access methods for PostgreSQL
ekorre1.0.0Unknown2026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for local Git repositories
redis_cluster_fdw1.0132026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for clustered Redis data
mufdw0.1Unknown2026-09-29Catalogue candidate; interface unverifiedMinimal local-table foreign data wrapper for teaching
pixels_fdw1.0Unknown2026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for Pixels columnar files
firebirdsql_fdw0.1.013, 14, 15, 16, 17, 182026-09-29Catalogue candidate; interface unverifiedRust foreign data wrapper for Firebird databases
tdengine_fdw1.015, 162026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for TDengine time-series databases
kite_fdw1.1Unknown2026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for remote Kite servers
pg_xdbc_fdw0.1132026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for XDBC data transfer
pgspider_core_fdw1.0Unknown2026-09-29Catalogue candidate; interface unverifiedPGSpider multi-source foreign-table query coordinator
pgspider_fdw1.4Unknown2026-09-29Catalogue candidate; interface unverifiedForeign data wrapper for remote PGSpider nodes
blackhole_fdw0.0.1Unknown2026-09-29Catalogue candidate; interface unverifiedBlack-hole foreign tables that discard writes and return no rows

Primary-source capability observations

Each statement applies to its named extension version and immutable source revision. Unlisted capabilities remain unknown. These are documentation observations, not runtime tests or current maintenance guarantees.

5 directory rows.

ExtensionReviewed versionCapabilityEvidence stateConditionsEvidence date and source
oracle_fdw2.9.0Predicate pushdownConditionalTranslatable conditions can run in Oracle; EXPLAIN exposes the remote query.2026-09-29 · 3ea9a4522c44 · README.oracle_fdw
oracle_fdw2.9.0Join pushdownConditionalTwo tables on one server, in SELECT, with shippable predicates; cross joins and three-table joins are excluded. A pushed join prevents ORDER BY pushdown.2026-09-29 · 3ea9a4522c44 · README.oracle_fdw
oracle_fdw2.9.0WritesConditionalINSERT, UPDATE and DELETE are supported unless readonly is set. UPDATE and DELETE require every Oracle primary-key column to have key enabled.2026-09-29 · 3ea9a4522c44 · README.oracle_fdw
oracle_fdw2.9.0TransactionsConditionalTransaction commands and savepoints reach Oracle. Oracle commits before PostgreSQL, so distributed commit is not atomic.2026-09-29 · 3ea9a4522c44 · README.oracle_fdw
oracle_fdw2.9.0Aggregate pushdownUnknownThis review has not established aggregate pushdown.2026-09-29 · 3ea9a4522c44 · README.oracle_fdw

Reading this collection

Core wrappers have PostgreSQL-version snapshots. Extension directory observations have their own dates and versions and link to the existing extension catalog. Classification or declared compatibility does not establish a capability; unverified cells remain unknown.