UniChem PostgreSQL Foreign Data Wrapper

unichem-fdw-query.sql

SELECT * 
  FROM credo.unichem_pdb_to_kegg
 LIMIT 10;

het_id compound_id 
------ -----------
LQZ    C07073
HC4    C00811
DC5    C14355
POD    C10874
FAH    C06108
AIC    C06574
SLI    C18915
BTN    C00120
DO4    C00433
APR    C00301
(10 rows)

Time: 424.420 ms

unichem-fdw.sql

CREATE extension multicorn;

CREATE SERVER unichem_srv FOREIGN DATA WRAPPER multicorn
    OPTIONS (wrapper 'scifdw.UniChemForeignDataWrapper');

CREATE FOREIGN TABLE credo.unichem_pdb_to_kegg (
    het_id text,
    compound_id text 
) SERVER unichem_srv
         OPTIONS (method 'mapping',
                  src_id '3',
                  to_src_id '6');