Skip to content

Latest commit

 

History

History
19 lines (14 loc) · 626 Bytes

README.md

File metadata and controls

19 lines (14 loc) · 626 Bytes
Raw

Yet Another Postgres FDW for MongoDB

based on multicorn

How to use:

Install Postgres
Install Multicorn
sudo python setup.py install

CREATE EXTENSION multicorn;
CREATE create SERVER mongodb_proxy_server FOREIGN DATA WRAPPER multicorn OPTIONS (wrapper 'yam_fdw.Yamfdw');
CREATE FOREIGN TABLE foo ( "_id" varchar OPTIONS (type 'ObjectId'), f1_f2 numeric OPTIONS (mname 'a.b'), d varchar )
   SERVER mongodb_proxy_server OPTIONS ( db 'test', collection 'foo' [, host 'hostNameOrIp', port: '27017', user 'myusername', password 'mypassword' ] );