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
|