npm

virtualpg

Loadable dynamic extension for SQLite and SpatiaLite

brewmacoslinux

Try with needOr install directly

Source

About

Loadable dynamic extension for SQLite and SpatiaLite

Commands

virtualpg

Examples

Load the VirtualPG extension in SQLite to access PostgreSQL tables

$ sqlite3 mydb.db ".load $(brew --prefix virtualpg)/lib/virtualpg" "CREATE VIRTUAL TABLE remote USING virtualpg('host=localhost user=postgres');"

Query PostgreSQL data through SQLite using VirtualPG extension$ sqlite3 mydb.db ".load $(brew --prefix virtualpg)/lib/virtualpg" "SELECT * FROM remote_pg_table;"

Use VirtualPG with SpatiaLite for spatial queries on remote PostGIS data$ sqlite3 mydb.db ".load $(brew --prefix virtualpg)/lib/virtualpg" "SELECT ST_AsText(geom) FROM remote_spatial_table;"