Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
UniChem PostgreSQL Foreign Data Wrapper
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
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');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.