This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: FDW

FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…

FDW category has 21 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
wrappers wrappers PIGSTY 0.4.3 FDW Apache-2.0 Foreign data wrappers developed by Supabase
multicorn multicorn PGDG 3.0 FDW PostgreSQL Fetch foreign data in Python in your PostgreSQL server.
odbc_fdw odbc_fdw PGDG 0.5.1 FDW PostgreSQL Foreign data wrapper for accessing remote databases using ODBC
jdbc_fdw jdbc_fdw PGDG 1.2 FDW PostgreSQL foreign-data wrapper for remote servers available over JDBC
mysql_fdw mysql_fdw PGDG 1.2 FDW BSD 3 Foreign data wrapper for querying a MySQL server
oracle_fdw oracle_fdw PGDG 1.2 FDW PostgreSQL foreign data wrapper for Oracle access
tds_fdw tds_fdw PGDG 2.0.4 FDW PostgreSQL Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdw db2_fdw PGDG 6.0.1 FDW PostgreSQL foreign data wrapper for DB2 access
sqlite_fdw sqlite_fdw PGDG 1.1 FDW PostgreSQL SQLite Foreign Data Wrapper
pgbouncer_fdw pgbouncer_fdw PGDG 1.2.0 FDW PostgreSQL Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
mongo_fdw mongo_fdw PGDG 1.1 FDW LGPLv3 foreign data wrapper for MongoDB access
redis_fdw redis_fdw PIGSTY 1.0 FDW PostgreSQL Foreign data wrapper for querying a Redis server
redis pg_redis_pubsub PIGSTY 0.0.1 FDW MIT Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw kafka_fdw PIGSTY 0.0.3 FDW PostgreSQL kafka Foreign Data Wrapper for CSV formated messages
hdfs_fdw hdfs_fdw PGDG 2.0.5 FDW BSD 3 foreign-data wrapper for remote hdfs servers
firebird_fdw firebird_fdw PIGSTY 1.4.0 FDW PostgreSQL Foreign data wrapper for Firebird
aws_s3 aws_s3 PIGSTY 0.0.1 FDW Apache-2.0 aws_s3 postgres extension to import/export data from/to s3
log_fdw log_fdw PIGSTY 1.4 FDW Apache-2.0 foreign-data wrapper for Postgres log file access
dblink dblink CONTRIB 1.2 FDW PostgreSQL connect to other PostgreSQL databases from within a database
file_fdw file_fdw CONTRIB 1.0 FDW PostgreSQL foreign-data wrapper for flat file access
postgres_fdw postgres_fdw CONTRIB 1.1 FDW PostgreSQL foreign-data wrapper for remote PostgreSQL servers

1 - wrappers

Foreign data wrappers developed by Supabase

Overview

PIGSTY 3rd Party Extension: wrappers : Foreign data wrappers developed by Supabase

Information

Metadata

  • Version: 0.4.3
  • PG Vers: 17,16,15,14
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: wrappers_$v
  • RPM Ver : 0.4.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-wrappers
  • DEB Ver : 0.4.3
  • DEB Deps: Nil

Details

2 - multicorn

Fetch foreign data in Python in your PostgreSQL server.

Overview

PGDG 1st Party Extension: multicorn : Fetch foreign data in Python in your PostgreSQL server.

Information

Metadata

  • Version: 3.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: multicorn2_$v*
  • RPM Ver : 3.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

3 - odbc_fdw

Foreign data wrapper for accessing remote databases using ODBC

Overview

PGDG 1st Party Extension: odbc_fdw : Foreign data wrapper for accessing remote databases using ODBC

Information

Metadata

  • Version: 0.5.1
  • PG Vers: 16,15,14,13
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: odbc_fdw_$v*
  • RPM Ver : 0.5.1
  • RPM Deps: unixODBC
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

4 - jdbc_fdw

foreign-data wrapper for remote servers available over JDBC

Overview

PGDG 1st Party Extension: jdbc_fdw : foreign-data wrapper for remote servers available over JDBC

Information

Metadata

  • Version: 1.2
  • PG Vers: 16,15,14,13
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: jdbc_fdw_$v*
  • RPM Ver : 1.2
  • RPM Deps: java-11-openjdk-headless
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

5 - mysql_fdw

Foreign data wrapper for querying a MySQL server

Overview

PGDG 1st Party Extension: mysql_fdw : Foreign data wrapper for querying a MySQL server

Information

Metadata

  • Version: 1.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: mysql_fdw_$v*
  • RPM Ver : 1.2
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-mysql-fdw
  • DEB Ver : 1.2
  • DEB Deps: Nil

Details

6 - oracle_fdw

foreign data wrapper for Oracle access

Overview

PGDG 1st Party Extension: oracle_fdw : foreign data wrapper for Oracle access

Information

Metadata

  • Version: 1.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: oracle_fdw_$v*
  • RPM Ver : 1.2
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-oracle-fdw
  • DEB Ver : 1.2
  • DEB Deps: Nil

Details

7 - tds_fdw

Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)

Overview

PGDG 1st Party Extension: tds_fdw : Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)

Information

Metadata

  • Version: 2.0.4
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: tds_fdw_$v*
  • RPM Ver : 2.0.4
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-tds-fdw
  • DEB Ver : 2.0.4
  • DEB Deps: Nil

Details

8 - db2_fdw

foreign data wrapper for DB2 access

Overview

PGDG 1st Party Extension: db2_fdw : foreign data wrapper for DB2 access

Information

Metadata

  • Version: 6.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: db2_fdw_$v*
  • RPM Ver : 6.0.1
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

9 - sqlite_fdw

SQLite Foreign Data Wrapper

Overview

PGDG 1st Party Extension: sqlite_fdw : SQLite Foreign Data Wrapper

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: sqlite_fdw_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-sqlite-fdw
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

10 - pgbouncer_fdw

Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions

Overview

PGDG 1st Party Extension: pgbouncer_fdw : Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions

Information

Metadata

  • Version: 1.2.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgbouncer_fdw_$v*
  • RPM Ver : 1.2.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

11 - mongo_fdw

foreign data wrapper for MongoDB access

Overview

PGDG 1st Party Extension: mongo_fdw : foreign data wrapper for MongoDB access

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: mongo_fdw_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

12 - redis_fdw

Foreign data wrapper for querying a Redis server

Overview

PIGSTY 3rd Party Extension: redis_fdw : Foreign data wrapper for querying a Redis server

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: redis_fdw_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-redis-fdw
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

13 - redis

Send redis pub/sub messages to Redis from PostgreSQL Directly

Overview

PIGSTY 3rd Party Extension: pg_redis_pubsub : Send redis pub/sub messages to Redis from PostgreSQL Directly

Information

Metadata

  • Version: 0.0.1
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_redis_pubsub_$v*
  • RPM Ver : 0.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-redis-pubsub
  • DEB Ver : 0.0.1
  • DEB Deps: Nil

Details

14 - kafka_fdw

kafka Foreign Data Wrapper for CSV formated messages

Overview

PIGSTY 3rd Party Extension: kafka_fdw : kafka Foreign Data Wrapper for CSV formated messages

Information

Metadata

  • Version: 0.0.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: kafka_fdw_$v
  • RPM Ver : 0.0.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-kafka-fdw
  • DEB Ver : 0.0.3
  • DEB Deps: Nil

Details

15 - hdfs_fdw

foreign-data wrapper for remote hdfs servers

Overview

PGDG 1st Party Extension: hdfs_fdw : foreign-data wrapper for remote hdfs servers

Information

Metadata

  • Version: 2.0.5
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: hdfs_fdw_$v*
  • RPM Ver : 2.0.5
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

16 - firebird_fdw

Foreign data wrapper for Firebird

Overview

PIGSTY 3rd Party Extension: firebird_fdw : Foreign data wrapper for Firebird

Information

Metadata

  • Version: 1.4.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: firebird_fdw_$v
  • RPM Ver : 1.4.0
  • RPM Deps: libfq
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

17 - aws_s3

aws_s3 postgres extension to import/export data from/to s3

Overview

PIGSTY 3rd Party Extension: aws_s3 : aws_s3 postgres extension to import/export data from/to s3

Information

Metadata

  • Version: 0.0.1
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: aws_s3_$v
  • RPM Ver : 0.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-aws-s3
  • DEB Ver : 0.0.1
  • DEB Deps: Nil

Details

18 - log_fdw

foreign-data wrapper for Postgres log file access

Overview

PIGSTY 3rd Party Extension: log_fdw : foreign-data wrapper for Postgres log file access

Information

Metadata

  • Version: 1.4
  • PG Vers: 17,16,15,14
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: log_fdw_$v*
  • RPM Ver : 1.4
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-log-fdw
  • DEB Ver : 1.4
  • DEB Deps: Nil

Details

19 - dblink

connect to other PostgreSQL databases from within a database

Overview

CONTRIB Built-in Extension: dblink : connect to other PostgreSQL databases from within a database

Information

Metadata

  • Version: 1.2
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

20 - file_fdw

foreign-data wrapper for flat file access

Overview

CONTRIB Built-in Extension: file_fdw : foreign-data wrapper for flat file access

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

21 - postgres_fdw

foreign-data wrapper for remote PostgreSQL servers

Overview

CONTRIB Built-in Extension: postgres_fdw : foreign-data wrapper for remote PostgreSQL servers

Information

Metadata

  • Version: 1.1
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details