SQLite Foreign Data Wrapper for PostgreSQL

This PostgreSQL extension is a Foreign Data Wrapper for SQLite.
This version of sqlite_fdw can work with PostgreSQL 9.6 and 10.

1. Installation

1. Install SQLite library

For debian or ubuntu:

apt-get install libsqlite3-dev

You can also download SQLite source code and build SQLite.

2. Build and install sqlite_fdw

Add a directory of pg_config to PATH and build and install sqlite_fdw.

make USE_PGXS=1
make install USE_PGXS=1

If you want to build sqlite_fdw in a source tree of PostgreSQL, use

make
make install

2. Usage

Load extension:

CREATE EXTENSION sqlite_fdw;

Create server specifying SQLite database path as option:

CREATE SERVER sqlite_server FOREIGN DATA WRAPPER sqlite_fdw OPTIONS (database '/tmp/test.db');

Create foreign table:

CREATE FOREIGN TABLE t1(a integer, b text) SERVER sqlite_server OPTIONS (table 't1_sqlite');

Or you can use import foreign schema:

IMPORT FOREIGN SCHEMA public FROM SERVER sqlite_server INTO public;

Access foregin table:

SELECT * FROM t1;

3. Features

Support update to foreign table
WHERE clauses are pushdowned
Aggregate function are pushdowned (PostgreSQL 10 only)
Transactions

4. Limitations

Nothing.

5. License

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

See the LICENSE file for full details.

KyleLilly/sqlite_fdw