sqlite_fdw

Extensions

sqlite_fdw

sqlite_fdw : SQLite Foreign Data Wrapper

Overview

ID	Extension	Package	Version	Category	License	Language
8640	sqlite_fdw	sqlite_fdw	`2.5.0`	FDW	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
See Also	mysql_fdw file_fdw postgres_fdw wrappers multicorn odbc_fdw jdbc_fdw duckdb_fdw

break on el8 due to sqlite-lib version low

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`2.5.0`	18 17 16 15 14	`sqlite_fdw`	-
RPM	PGDG	`2.5.0`	18 17 16 15 14	`sqlite_fdw_$v`	-
DEB	PGDG	`2.5.0`	18 17 16 15 14	`postgresql-$v-sqlite-fdw`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	MISS	PGDG 2.4.0	PGDG 2.4.0	PGDG 2.4.0	PGDG 2.4.0
el8.aarch64	MISS	PGDG 2.4.0	PGDG 2.4.0	PGDG 2.4.0	PGDG 2.4.0
el9.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
el9.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
el10.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
el10.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
d12.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
d12.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
d13.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
d13.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
u22.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
u22.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
u24.x86_64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0
u24.aarch64	MISS	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0	PIGSTY 2.5.0

Package	Version	OS	ORG	SIZE	File URL
`sqlite_fdw_17`	`2.4.0`	el8.x86_64	pgdg	57.9 KiB	sqlite_fdw_17-2.4.0-4PGDG.rhel8.x86_64.rpm
`sqlite_fdw_17`	`2.4.0`	el8.aarch64	pgdg	55.3 KiB	sqlite_fdw_17-2.4.0-4PGDG.rhel8.aarch64.rpm
`sqlite_fdw_17`	`2.5.0`	el9.x86_64	pigsty	65.7 KiB	sqlite_fdw_17-2.5.0-2PIGSTY.el9.x86_64.rpm
`sqlite_fdw_17`	`2.5.0`	el9.x86_64	pgdg	64.9 KiB	sqlite_fdw_17-2.5.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_17`	`2.4.0`	el9.x86_64	pgdg	56.9 KiB	sqlite_fdw_17-2.4.0-4PGDG.rhel9.x86_64.rpm
`sqlite_fdw_17`	`2.5.0`	el9.aarch64	pigsty	64.1 KiB	sqlite_fdw_17-2.5.0-2PIGSTY.el9.aarch64.rpm
`sqlite_fdw_17`	`2.5.0`	el9.aarch64	pgdg	63.3 KiB	sqlite_fdw_17-2.5.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_17`	`2.4.0`	el9.aarch64	pgdg	55.3 KiB	sqlite_fdw_17-2.4.0-4PGDG.rhel9.aarch64.rpm
`sqlite_fdw_17`	`2.5.0`	el10.x86_64	pigsty	67.1 KiB	sqlite_fdw_17-2.5.0-2PIGSTY.el10.x86_64.rpm
`sqlite_fdw_17`	`2.5.0`	el10.x86_64	pgdg	66.8 KiB	sqlite_fdw_17-2.5.0-2PGDG.rhel10.x86_64.rpm
`sqlite_fdw_17`	`2.5.0`	el10.aarch64	pigsty	65.1 KiB	sqlite_fdw_17-2.5.0-2PIGSTY.el10.aarch64.rpm
`sqlite_fdw_17`	`2.5.0`	el10.aarch64	pgdg	64.6 KiB	sqlite_fdw_17-2.5.0-2PGDG.rhel10.aarch64.rpm
`postgresql-17-sqlite-fdw`	`2.5.0`	d12.x86_64	pigsty	153.7 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~bookworm_amd64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	d12.aarch64	pigsty	148.9 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~bookworm_arm64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	d13.x86_64	pigsty	154.1 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~trixie_amd64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	d13.aarch64	pigsty	150.0 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~trixie_arm64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	u22.x86_64	pigsty	188.4 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~jammy_amd64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	u22.aarch64	pigsty	185.7 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~jammy_arm64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	u24.x86_64	pigsty	159.5 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~noble_amd64.deb
`postgresql-17-sqlite-fdw`	`2.5.0`	u24.aarch64	pigsty	156.8 KiB	postgresql-17-sqlite-fdw_2.5.0-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`sqlite_fdw_16`	`2.4.0`	el8.x86_64	pgdg	57.6 KiB	sqlite_fdw_16-2.4.0-1PGDG.rhel8.x86_64.rpm
`sqlite_fdw_16`	`2.4.0`	el8.aarch64	pgdg	55.1 KiB	sqlite_fdw_16-2.4.0-1PGDG.rhel8.aarch64.rpm
`sqlite_fdw_16`	`2.5.0`	el9.x86_64	pigsty	64.8 KiB	sqlite_fdw_16-2.5.0-2PIGSTY.el9.x86_64.rpm
`sqlite_fdw_16`	`2.5.0`	el9.x86_64	pgdg	63.9 KiB	sqlite_fdw_16-2.5.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_16`	`2.4.0`	el9.x86_64	pgdg	56.4 KiB	sqlite_fdw_16-2.4.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_16`	`2.5.0`	el9.aarch64	pigsty	63.2 KiB	sqlite_fdw_16-2.5.0-2PIGSTY.el9.aarch64.rpm
`sqlite_fdw_16`	`2.5.0`	el9.aarch64	pgdg	62.5 KiB	sqlite_fdw_16-2.5.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_16`	`2.4.0`	el9.aarch64	pgdg	54.8 KiB	sqlite_fdw_16-2.4.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_16`	`2.5.0`	el10.x86_64	pigsty	66.1 KiB	sqlite_fdw_16-2.5.0-2PIGSTY.el10.x86_64.rpm
`sqlite_fdw_16`	`2.5.0`	el10.x86_64	pgdg	65.8 KiB	sqlite_fdw_16-2.5.0-2PGDG.rhel10.x86_64.rpm
`sqlite_fdw_16`	`2.5.0`	el10.aarch64	pigsty	64.2 KiB	sqlite_fdw_16-2.5.0-2PIGSTY.el10.aarch64.rpm
`sqlite_fdw_16`	`2.5.0`	el10.aarch64	pgdg	63.8 KiB	sqlite_fdw_16-2.5.0-2PGDG.rhel10.aarch64.rpm
`postgresql-16-sqlite-fdw`	`2.5.0`	d12.x86_64	pigsty	151.7 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~bookworm_amd64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	d12.aarch64	pigsty	147.4 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~bookworm_arm64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	d13.x86_64	pigsty	152.0 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~trixie_amd64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	d13.aarch64	pigsty	148.0 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~trixie_arm64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	u22.x86_64	pigsty	183.5 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~jammy_amd64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	u22.aarch64	pigsty	181.0 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~jammy_arm64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	u24.x86_64	pigsty	157.0 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~noble_amd64.deb
`postgresql-16-sqlite-fdw`	`2.5.0`	u24.aarch64	pigsty	155.1 KiB	postgresql-16-sqlite-fdw_2.5.0-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`sqlite_fdw_15`	`2.4.0`	el8.x86_64	pgdg	58.0 KiB	sqlite_fdw_15-2.4.0-1PGDG.rhel8.x86_64.rpm
`sqlite_fdw_15`	`2.3.0`	el8.x86_64	pgdg	53.4 KiB	sqlite_fdw_15-2.3.0-1.rhel8.x86_64.rpm
`sqlite_fdw_15`	`2.2.0`	el8.x86_64	pgdg	159.1 KiB	sqlite_fdw_15-2.2.0-1.rhel8.x86_64.rpm
`sqlite_fdw_15`	`2.4.0`	el8.aarch64	pgdg	55.4 KiB	sqlite_fdw_15-2.4.0-1PGDG.rhel8.aarch64.rpm
`sqlite_fdw_15`	`2.3.0`	el8.aarch64	pgdg	50.6 KiB	sqlite_fdw_15-2.3.0-1.rhel8.aarch64.rpm
`sqlite_fdw_15`	`2.2.0`	el8.aarch64	pgdg	155.8 KiB	sqlite_fdw_15-2.2.0-1.rhel8.aarch64.rpm
`sqlite_fdw_15`	`2.5.0`	el9.x86_64	pigsty	67.0 KiB	sqlite_fdw_15-2.5.0-2PIGSTY.el9.x86_64.rpm
`sqlite_fdw_15`	`2.5.0`	el9.x86_64	pgdg	66.1 KiB	sqlite_fdw_15-2.5.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_15`	`2.4.0`	el9.x86_64	pgdg	58.1 KiB	sqlite_fdw_15-2.4.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_15`	`2.3.0`	el9.x86_64	pgdg	53.5 KiB	sqlite_fdw_15-2.3.0-1.rhel9.x86_64.rpm
`sqlite_fdw_15`	`2.2.0`	el9.x86_64	pgdg	162.0 KiB	sqlite_fdw_15-2.2.0-1.rhel9.x86_64.rpm
`sqlite_fdw_15`	`2.5.0`	el9.aarch64	pigsty	65.7 KiB	sqlite_fdw_15-2.5.0-2PIGSTY.el9.aarch64.rpm
`sqlite_fdw_15`	`2.5.0`	el9.aarch64	pgdg	64.6 KiB	sqlite_fdw_15-2.5.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_15`	`2.4.0`	el9.aarch64	pgdg	56.6 KiB	sqlite_fdw_15-2.4.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_15`	`2.3.0`	el9.aarch64	pgdg	52.3 KiB	sqlite_fdw_15-2.3.0-1.rhel9.aarch64.rpm
`sqlite_fdw_15`	`2.2.0`	el9.aarch64	pgdg	159.6 KiB	sqlite_fdw_15-2.2.0-1.rhel9.aarch64.rpm
`sqlite_fdw_15`	`2.5.0`	el10.x86_64	pigsty	68.0 KiB	sqlite_fdw_15-2.5.0-2PIGSTY.el10.x86_64.rpm
`sqlite_fdw_15`	`2.5.0`	el10.x86_64	pgdg	67.6 KiB	sqlite_fdw_15-2.5.0-2PGDG.rhel10.x86_64.rpm
`sqlite_fdw_15`	`2.5.0`	el10.aarch64	pigsty	66.7 KiB	sqlite_fdw_15-2.5.0-2PIGSTY.el10.aarch64.rpm
`sqlite_fdw_15`	`2.5.0`	el10.aarch64	pgdg	66.0 KiB	sqlite_fdw_15-2.5.0-2PGDG.rhel10.aarch64.rpm
`postgresql-15-sqlite-fdw`	`2.5.0`	d12.x86_64	pigsty	152.6 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~bookworm_amd64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	d12.aarch64	pigsty	148.2 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~bookworm_arm64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	d13.x86_64	pigsty	152.9 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~trixie_amd64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	d13.aarch64	pigsty	148.8 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~trixie_arm64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	u22.x86_64	pigsty	185.2 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~jammy_amd64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	u22.aarch64	pigsty	183.0 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~jammy_arm64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	u24.x86_64	pigsty	158.6 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~noble_amd64.deb
`postgresql-15-sqlite-fdw`	`2.5.0`	u24.aarch64	pigsty	157.2 KiB	postgresql-15-sqlite-fdw_2.5.0-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`sqlite_fdw_14`	`2.4.0`	el8.x86_64	pgdg	58.1 KiB	sqlite_fdw_14-2.4.0-1PGDG.rhel8.x86_64.rpm
`sqlite_fdw_14`	`2.3.0`	el8.x86_64	pgdg	53.4 KiB	sqlite_fdw_14-2.3.0-1.rhel8.x86_64.rpm
`sqlite_fdw_14`	`2.1.1`	el8.x86_64	pgdg	157.0 KiB	sqlite_fdw_14-2.1.1-1.rhel8.x86_64.rpm
`sqlite_fdw_14`	`2.1.0`	el8.x86_64	pgdg	154.8 KiB	sqlite_fdw_14-2.1.0-1.rhel8.x86_64.rpm
`sqlite_fdw_14`	`2.4.0`	el8.aarch64	pgdg	55.5 KiB	sqlite_fdw_14-2.4.0-1PGDG.rhel8.aarch64.rpm
`sqlite_fdw_14`	`2.3.0`	el8.aarch64	pgdg	50.7 KiB	sqlite_fdw_14-2.3.0-1.rhel8.aarch64.rpm
`sqlite_fdw_14`	`2.2.0`	el8.aarch64	pgdg	156.4 KiB	sqlite_fdw_14-2.2.0-1.rhel8.aarch64.rpm
`sqlite_fdw_14`	`2.5.0`	el9.x86_64	pigsty	67.1 KiB	sqlite_fdw_14-2.5.0-2PIGSTY.el9.x86_64.rpm
`sqlite_fdw_14`	`2.5.0`	el9.x86_64	pgdg	66.1 KiB	sqlite_fdw_14-2.5.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_14`	`2.4.0`	el9.x86_64	pgdg	58.2 KiB	sqlite_fdw_14-2.4.0-1PGDG.rhel9.x86_64.rpm
`sqlite_fdw_14`	`2.3.0`	el9.x86_64	pgdg	53.6 KiB	sqlite_fdw_14-2.3.0-1.rhel9.x86_64.rpm
`sqlite_fdw_14`	`2.1.1`	el9.x86_64	pgdg	159.0 KiB	sqlite_fdw_14-2.1.1-1.rhel9.x86_64.rpm
`sqlite_fdw_14`	`2.5.0`	el9.aarch64	pigsty	65.7 KiB	sqlite_fdw_14-2.5.0-2PIGSTY.el9.aarch64.rpm
`sqlite_fdw_14`	`2.5.0`	el9.aarch64	pgdg	64.7 KiB	sqlite_fdw_14-2.5.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_14`	`2.4.0`	el9.aarch64	pgdg	56.7 KiB	sqlite_fdw_14-2.4.0-1PGDG.rhel9.aarch64.rpm
`sqlite_fdw_14`	`2.3.0`	el9.aarch64	pgdg	52.2 KiB	sqlite_fdw_14-2.3.0-1.rhel9.aarch64.rpm
`sqlite_fdw_14`	`2.2.0`	el9.aarch64	pgdg	160.4 KiB	sqlite_fdw_14-2.2.0-1.rhel9.aarch64.rpm
`sqlite_fdw_14`	`2.5.0`	el10.x86_64	pigsty	68.4 KiB	sqlite_fdw_14-2.5.0-2PIGSTY.el10.x86_64.rpm
`sqlite_fdw_14`	`2.5.0`	el10.x86_64	pgdg	67.7 KiB	sqlite_fdw_14-2.5.0-2PGDG.rhel10.x86_64.rpm
`sqlite_fdw_14`	`2.5.0`	el10.aarch64	pigsty	66.7 KiB	sqlite_fdw_14-2.5.0-2PIGSTY.el10.aarch64.rpm
`sqlite_fdw_14`	`2.5.0`	el10.aarch64	pgdg	66.0 KiB	sqlite_fdw_14-2.5.0-2PGDG.rhel10.aarch64.rpm
`postgresql-14-sqlite-fdw`	`2.5.0`	d12.x86_64	pigsty	152.8 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~bookworm_amd64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	d12.aarch64	pigsty	148.5 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~bookworm_arm64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	d13.x86_64	pigsty	153.3 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~trixie_amd64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	d13.aarch64	pigsty	149.2 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~trixie_arm64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	u22.x86_64	pigsty	185.4 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~jammy_amd64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	u22.aarch64	pigsty	183.4 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~jammy_arm64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	u24.x86_64	pigsty	159.1 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~noble_amd64.deb
`postgresql-14-sqlite-fdw`	`2.5.0`	u24.aarch64	pigsty	157.4 KiB	postgresql-14-sqlite-fdw_2.5.0-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/pgspider/sqlite_fdw

Source Tarball

sqlite_fdw-2.5.0.tar.gz

pig build pkg sqlite_fdw;		# build rpm/deb

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install sqlite_fdw;		# install via package name, for the active PG version

pig install sqlite_fdw -v 17;   # install for PG 17
pig install sqlite_fdw -v 16;   # install for PG 16
pig install sqlite_fdw -v 15;   # install for PG 15
pig install sqlite_fdw -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION sqlite_fdw;

Last updated on 2026-03-08

db2_fdw pgbouncer_fdw