PostgreSQL foreign data wrappers

GPTKB entity

Statements (40)
Predicate Object
gptkbp:instanceOf PostgreSQL extension
gptkbp:allows creation of foreign tables
gptkbp:can_be_written_as gptkb:PL/Perl
gptkb:PL/Python
C
PL/Java
gptkbp:canBe gptkb:PostgreSQL
gptkbp:documentation https://www.postgresql.org/docs/current/ddl-foreign-data.html
gptkbp:enables data integration
data federation
access to external data sources
querying remote databases
gptkbp:example gptkb:postgres_fdw
file_fdw
mongo_fdw
mysql_fdw
odbc_fdw
oracle_fdw
gptkbp:hasConnection NoSQL databases
heterogeneous databases
ODBC data sources
flat files
other PostgreSQL servers
https://www.w3.org/2000/01/rdf-schema#label PostgreSQL foreign data wrappers
gptkbp:implementedIn gptkb:SQL/MED_standard
gptkbp:introducedIn gptkb:PostgreSQL_9.1
gptkbp:managedBy gptkb:postgres_fdw_extension
gptkbp:partOf PostgreSQL ecosystem
gptkbp:requires CREATE EXTENSION command
gptkbp:supports pushdown of WHERE clauses
pushdown of joins (in some FDWs)
read-only access (in some FDWs)
read-write access (in some FDWs)
gptkbp:uses CREATE FOREIGN TABLE SQL command
CREATE SERVER SQL command
CREATE USER MAPPING SQL command
FOREIGN DATA WRAPPER SQL command
IMPORT FOREIGN SCHEMA SQL command
gptkbp:bfsParent gptkb:dblink_extension
gptkbp:bfsLayer 6