PostgreSQL foreign data wrappers
GPTKB entity
Statements (40)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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 |
| 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 |
7
|
| https://www.w3.org/2000/01/rdf-schema#label |
PostgreSQL foreign data wrappers
|