re2

re2 : ClickHouse-compatible regex functions using RE2

Overview

ID Extension Package Version Category License Language
4235
re2
re2
0.1.1
UTIL
PostgreSQL
C++
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-dtr
No
Yes
No
Yes
yes
yes

release 0.1.1; SQL v0.1

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
0.1.1
18
17
16
15
14
re2 -
RPM
PIGSTY
0.1.1
18
17
16
15
14
re2_$v -
DEB
PIGSTY
0.1.1
18
17
16
15
14
postgresql-$v-re2 -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
el8.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
el9.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
el9.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
el10.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
el10.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
d12.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
d12.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
d13.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
d13.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
u22.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
u22.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
u24.x86_64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
u24.aarch64
PIGSTY 0.1.1
PIGSTY 0.1.1
PIGSTY 0.1.1
MISS
MISS
Package Version OS ORG SIZE File URL
re2_18 0.1.1 el8.x86_64 pigsty 25.7 KiB re2_18-0.1.1-1PIGSTY.el8.x86_64.rpm
re2_18 0.1.1 el8.aarch64 pigsty 25.1 KiB re2_18-0.1.1-1PIGSTY.el8.aarch64.rpm
re2_18 0.1.1 el9.x86_64 pigsty 25.8 KiB re2_18-0.1.1-1PIGSTY.el9.x86_64.rpm
re2_18 0.1.1 el9.aarch64 pigsty 25.1 KiB re2_18-0.1.1-1PIGSTY.el9.aarch64.rpm
re2_18 0.1.1 el10.x86_64 pigsty 25.8 KiB re2_18-0.1.1-1PIGSTY.el10.x86_64.rpm
re2_18 0.1.1 el10.aarch64 pigsty 25.3 KiB re2_18-0.1.1-1PIGSTY.el10.aarch64.rpm
postgresql-18-re2 0.1.1 d12.x86_64 pigsty 37.3 KiB postgresql-18-re2_0.1.1-1PIGSTY~bookworm_amd64.deb
postgresql-18-re2 0.1.1 d12.aarch64 pigsty 36.6 KiB postgresql-18-re2_0.1.1-1PIGSTY~bookworm_arm64.deb
postgresql-18-re2 0.1.1 d13.x86_64 pigsty 38.6 KiB postgresql-18-re2_0.1.1-1PIGSTY~trixie_amd64.deb
postgresql-18-re2 0.1.1 d13.aarch64 pigsty 37.6 KiB postgresql-18-re2_0.1.1-1PIGSTY~trixie_arm64.deb
postgresql-18-re2 0.1.1 u22.x86_64 pigsty 38.1 KiB postgresql-18-re2_0.1.1-1PIGSTY~jammy_amd64.deb
postgresql-18-re2 0.1.1 u22.aarch64 pigsty 37.5 KiB postgresql-18-re2_0.1.1-1PIGSTY~jammy_arm64.deb
postgresql-18-re2 0.1.1 u24.x86_64 pigsty 37.6 KiB postgresql-18-re2_0.1.1-1PIGSTY~noble_amd64.deb
postgresql-18-re2 0.1.1 u24.aarch64 pigsty 37.3 KiB postgresql-18-re2_0.1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
re2_17 0.1.1 el8.x86_64 pigsty 25.7 KiB re2_17-0.1.1-1PIGSTY.el8.x86_64.rpm
re2_17 0.1.1 el8.aarch64 pigsty 25.1 KiB re2_17-0.1.1-1PIGSTY.el8.aarch64.rpm
re2_17 0.1.1 el9.x86_64 pigsty 25.8 KiB re2_17-0.1.1-1PIGSTY.el9.x86_64.rpm
re2_17 0.1.1 el9.aarch64 pigsty 25.0 KiB re2_17-0.1.1-1PIGSTY.el9.aarch64.rpm
re2_17 0.1.1 el10.x86_64 pigsty 25.8 KiB re2_17-0.1.1-1PIGSTY.el10.x86_64.rpm
re2_17 0.1.1 el10.aarch64 pigsty 25.3 KiB re2_17-0.1.1-1PIGSTY.el10.aarch64.rpm
postgresql-17-re2 0.1.1 d12.x86_64 pigsty 37.1 KiB postgresql-17-re2_0.1.1-1PIGSTY~bookworm_amd64.deb
postgresql-17-re2 0.1.1 d12.aarch64 pigsty 36.4 KiB postgresql-17-re2_0.1.1-1PIGSTY~bookworm_arm64.deb
postgresql-17-re2 0.1.1 d13.x86_64 pigsty 38.3 KiB postgresql-17-re2_0.1.1-1PIGSTY~trixie_amd64.deb
postgresql-17-re2 0.1.1 d13.aarch64 pigsty 37.5 KiB postgresql-17-re2_0.1.1-1PIGSTY~trixie_arm64.deb
postgresql-17-re2 0.1.1 u22.x86_64 pigsty 39.6 KiB postgresql-17-re2_0.1.1-1PIGSTY~jammy_amd64.deb
postgresql-17-re2 0.1.1 u22.aarch64 pigsty 38.8 KiB postgresql-17-re2_0.1.1-1PIGSTY~jammy_arm64.deb
postgresql-17-re2 0.1.1 u24.x86_64 pigsty 37.4 KiB postgresql-17-re2_0.1.1-1PIGSTY~noble_amd64.deb
postgresql-17-re2 0.1.1 u24.aarch64 pigsty 37.1 KiB postgresql-17-re2_0.1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
re2_16 0.1.1 el8.x86_64 pigsty 25.7 KiB re2_16-0.1.1-1PIGSTY.el8.x86_64.rpm
re2_16 0.1.1 el8.aarch64 pigsty 25.1 KiB re2_16-0.1.1-1PIGSTY.el8.aarch64.rpm
re2_16 0.1.1 el9.x86_64 pigsty 25.8 KiB re2_16-0.1.1-1PIGSTY.el9.x86_64.rpm
re2_16 0.1.1 el9.aarch64 pigsty 25.0 KiB re2_16-0.1.1-1PIGSTY.el9.aarch64.rpm
re2_16 0.1.1 el10.x86_64 pigsty 25.8 KiB re2_16-0.1.1-1PIGSTY.el10.x86_64.rpm
re2_16 0.1.1 el10.aarch64 pigsty 25.3 KiB re2_16-0.1.1-1PIGSTY.el10.aarch64.rpm
postgresql-16-re2 0.1.1 d12.x86_64 pigsty 37.1 KiB postgresql-16-re2_0.1.1-1PIGSTY~bookworm_amd64.deb
postgresql-16-re2 0.1.1 d12.aarch64 pigsty 36.4 KiB postgresql-16-re2_0.1.1-1PIGSTY~bookworm_arm64.deb
postgresql-16-re2 0.1.1 d13.x86_64 pigsty 38.3 KiB postgresql-16-re2_0.1.1-1PIGSTY~trixie_amd64.deb
postgresql-16-re2 0.1.1 d13.aarch64 pigsty 37.4 KiB postgresql-16-re2_0.1.1-1PIGSTY~trixie_arm64.deb
postgresql-16-re2 0.1.1 u22.x86_64 pigsty 39.6 KiB postgresql-16-re2_0.1.1-1PIGSTY~jammy_amd64.deb
postgresql-16-re2 0.1.1 u22.aarch64 pigsty 38.8 KiB postgresql-16-re2_0.1.1-1PIGSTY~jammy_arm64.deb
postgresql-16-re2 0.1.1 u24.x86_64 pigsty 37.4 KiB postgresql-16-re2_0.1.1-1PIGSTY~noble_amd64.deb
postgresql-16-re2 0.1.1 u24.aarch64 pigsty 37.2 KiB postgresql-16-re2_0.1.1-1PIGSTY~noble_arm64.deb

Source

pig build pkg re2;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION re2;
Last updated on