Extensions
pg_rewrite

pg_rewrite

pg_rewrite : Tool allows read write to the table during the rewriting

Overview

ID Extension Package Version Category License Language
5020
pg_rewrite
pg_rewrite
 2.0.0
ADMIN
BSD 3-Clause
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd-r
No
Yes
Yes
Yes
yes
no
Relationships
See Also
pg_repack
pg_squeeze
pgfincore
pg_prewarm
pgstattuple
amcheck
pageinspect
pg_visibility

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 2.0.0
18
17
16
15
14
13
 pg_rewrite -
RPM
PGDG
 2.0.0
18
17
16
15
14
13
 pg_rewrite_$v* -
DEB
PGDG
 2.0.0
18
17
16
15
14
13
 postgresql-$v-pg-rewrite -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 2.0.0
PIGSTY 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
el8.aarch64
PGDG 2.0.0
PIGSTY 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
el9.x86_64
PGDG 2.0.0
PIGSTY 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
el9.aarch64
PGDG 2.0.0
PIGSTY 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
el10.x86_64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
el10.aarch64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
d12.x86_64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
d12.aarch64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
d13.x86_64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
d13.aarch64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
u22.x86_64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
u22.aarch64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
u24.x86_64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
u24.aarch64
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
PGDG 2.0.0
Package Version OS ORG SIZE File URL
pg_rewrite_18 2.0.0 el8.x86_64 pgdg 37.6 KiB pg_rewrite_18-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_18 2.0.0 el8.aarch64 pgdg 35.4 KiB pg_rewrite_18-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_18 2.0.0 el9.x86_64 pgdg 38.1 KiB pg_rewrite_18-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_18 2.0.0 el9.aarch64 pgdg 36.4 KiB pg_rewrite_18-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_18 2.0.0 el10.x86_64 pgdg 39.0 KiB pg_rewrite_18-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_18 2.0.0 el10.aarch64 pgdg 37.1 KiB pg_rewrite_18-2.0.0-1PGDG.rhel10.aarch64.rpm
postgresql-18-pg-rewrite 2.0.0 d12.x86_64 pgdg 76.0 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-18-pg-rewrite 2.0.0 d12.aarch64 pgdg 71.5 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-18-pg-rewrite 2.0.0 d13.x86_64 pgdg 75.9 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-18-pg-rewrite 2.0.0 d13.aarch64 pgdg 71.3 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-18-pg-rewrite 2.0.0 u22.x86_64 pgdg 78.6 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-18-pg-rewrite 2.0.0 u22.aarch64 pgdg 73.7 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-18-pg-rewrite 2.0.0 u24.x86_64 pgdg 76.1 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-18-pg-rewrite 2.0.0 u24.aarch64 pgdg 71.2 KiB postgresql-18-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_rewrite_17 2.0.0 el8.x86_64 pigsty 37.0 KiB pg_rewrite_17-2.0.0-1PIGSTY.el8.x86_64.rpm
pg_rewrite_17 2.0.0 el8.x86_64 pgdg 37.2 KiB pg_rewrite_17-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_17 2.0.0 el8.aarch64 pigsty 35.0 KiB pg_rewrite_17-2.0.0-1PIGSTY.el8.aarch64.rpm
pg_rewrite_17 2.0.0 el8.aarch64 pgdg 35.1 KiB pg_rewrite_17-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_17 2.0.0 el9.x86_64 pigsty 37.7 KiB pg_rewrite_17-2.0.0-1PIGSTY.el9.x86_64.rpm
pg_rewrite_17 2.0.0 el9.x86_64 pgdg 37.9 KiB pg_rewrite_17-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_17 2.0.0 el9.aarch64 pigsty 36.1 KiB pg_rewrite_17-2.0.0-1PIGSTY.el9.aarch64.rpm
pg_rewrite_17 2.0.0 el9.aarch64 pgdg 36.2 KiB pg_rewrite_17-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_17 2.0.0 el10.x86_64 pgdg 38.7 KiB pg_rewrite_17-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_17 2.0.0 el10.aarch64 pgdg 37.2 KiB pg_rewrite_17-2.0.0-1PGDG.rhel10.aarch64.rpm
postgresql-17-pg-rewrite 2.0.0 d12.x86_64 pgdg 75.5 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-17-pg-rewrite 2.0.0 d12.aarch64 pgdg 71.0 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-17-pg-rewrite 2.0.0 d13.x86_64 pgdg 75.4 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-17-pg-rewrite 2.0.0 d13.aarch64 pgdg 71.0 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-17-pg-rewrite 2.0.0 u22.x86_64 pgdg 90.3 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-17-pg-rewrite 2.0.0 u22.aarch64 pgdg 85.6 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-17-pg-rewrite 2.0.0 u24.x86_64 pgdg 75.6 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-17-pg-rewrite 2.0.0 u24.aarch64 pgdg 70.8 KiB postgresql-17-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_rewrite_16 2.0.0 el8.x86_64 pgdg 37.3 KiB pg_rewrite_16-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_16 1.1.0 el8.x86_64 pgdg 36.0 KiB pg_rewrite_16-1.1.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_16 2.0.0 el8.aarch64 pgdg 35.1 KiB pg_rewrite_16-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_16 1.1.0 el8.aarch64 pgdg 34.1 KiB pg_rewrite_16-1.1.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_16 2.0.0 el9.x86_64 pgdg 37.9 KiB pg_rewrite_16-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_16 1.1.0 el9.x86_64 pgdg 36.4 KiB pg_rewrite_16-1.1.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_16 2.0.0 el9.aarch64 pgdg 36.3 KiB pg_rewrite_16-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_16 1.1.0 el9.aarch64 pgdg 34.9 KiB pg_rewrite_16-1.1.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_16 2.0.0 el10.x86_64 pgdg 38.7 KiB pg_rewrite_16-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_16 1.1.0 el10.x86_64 pgdg 37.3 KiB pg_rewrite_16-1.1.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_16 2.0.0 el10.aarch64 pgdg 37.2 KiB pg_rewrite_16-2.0.0-1PGDG.rhel10.aarch64.rpm
pg_rewrite_16 1.1.0 el10.aarch64 pgdg 35.9 KiB pg_rewrite_16-1.1.0-1PGDG.rhel10.aarch64.rpm
postgresql-16-pg-rewrite 2.0.0 d12.x86_64 pgdg 75.4 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-16-pg-rewrite 2.0.0 d12.aarch64 pgdg 70.9 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-16-pg-rewrite 2.0.0 d13.x86_64 pgdg 75.1 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-16-pg-rewrite 2.0.0 d13.aarch64 pgdg 71.0 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-16-pg-rewrite 2.0.0 u22.x86_64 pgdg 89.4 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-16-pg-rewrite 2.0.0 u22.aarch64 pgdg 84.8 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-16-pg-rewrite 2.0.0 u24.x86_64 pgdg 75.4 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-16-pg-rewrite 2.0.0 u24.aarch64 pgdg 70.7 KiB postgresql-16-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_rewrite_15 2.0.0 el8.x86_64 pgdg 37.3 KiB pg_rewrite_15-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_15 1.1.0 el8.x86_64 pgdg 36.0 KiB pg_rewrite_15-1.1.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_15 2.0.0 el8.aarch64 pgdg 35.1 KiB pg_rewrite_15-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_15 1.1.0 el8.aarch64 pgdg 34.0 KiB pg_rewrite_15-1.1.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_15 2.0.0 el9.x86_64 pgdg 38.0 KiB pg_rewrite_15-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_15 1.1.0 el9.x86_64 pgdg 36.5 KiB pg_rewrite_15-1.1.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_15 2.0.0 el9.aarch64 pgdg 36.2 KiB pg_rewrite_15-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_15 1.1.0 el9.aarch64 pgdg 34.9 KiB pg_rewrite_15-1.1.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_15 2.0.0 el10.x86_64 pgdg 38.7 KiB pg_rewrite_15-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_15 1.1.0 el10.x86_64 pgdg 37.5 KiB pg_rewrite_15-1.1.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_15 2.0.0 el10.aarch64 pgdg 37.0 KiB pg_rewrite_15-2.0.0-1PGDG.rhel10.aarch64.rpm
pg_rewrite_15 1.1.0 el10.aarch64 pgdg 36.1 KiB pg_rewrite_15-1.1.0-1PGDG.rhel10.aarch64.rpm
postgresql-15-pg-rewrite 2.0.0 d12.x86_64 pgdg 75.2 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-15-pg-rewrite 2.0.0 d12.aarch64 pgdg 70.7 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-15-pg-rewrite 2.0.0 d13.x86_64 pgdg 75.0 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-15-pg-rewrite 2.0.0 d13.aarch64 pgdg 70.5 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-15-pg-rewrite 2.0.0 u22.x86_64 pgdg 89.4 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-15-pg-rewrite 2.0.0 u22.aarch64 pgdg 84.4 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-15-pg-rewrite 2.0.0 u24.x86_64 pgdg 75.1 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-15-pg-rewrite 2.0.0 u24.aarch64 pgdg 70.5 KiB postgresql-15-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_rewrite_14 2.0.0 el8.x86_64 pgdg 37.5 KiB pg_rewrite_14-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_14 1.1.0 el8.x86_64 pgdg 36.2 KiB pg_rewrite_14-1.1.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_14 2.0.0 el8.aarch64 pgdg 35.2 KiB pg_rewrite_14-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_14 1.1.0 el8.aarch64 pgdg 34.0 KiB pg_rewrite_14-1.1.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_14 2.0.0 el9.x86_64 pgdg 38.1 KiB pg_rewrite_14-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_14 1.1.0 el9.x86_64 pgdg 36.8 KiB pg_rewrite_14-1.1.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_14 2.0.0 el9.aarch64 pgdg 36.5 KiB pg_rewrite_14-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_14 1.1.0 el9.aarch64 pgdg 35.0 KiB pg_rewrite_14-1.1.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_14 2.0.0 el10.x86_64 pgdg 39.0 KiB pg_rewrite_14-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_14 1.1.0 el10.x86_64 pgdg 37.6 KiB pg_rewrite_14-1.1.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_14 2.0.0 el10.aarch64 pgdg 37.2 KiB pg_rewrite_14-2.0.0-1PGDG.rhel10.aarch64.rpm
pg_rewrite_14 1.1.0 el10.aarch64 pgdg 36.3 KiB pg_rewrite_14-1.1.0-1PGDG.rhel10.aarch64.rpm
postgresql-14-pg-rewrite 2.0.0 d12.x86_64 pgdg 75.5 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-14-pg-rewrite 2.0.0 d12.aarch64 pgdg 70.9 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-14-pg-rewrite 2.0.0 d13.x86_64 pgdg 75.1 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-14-pg-rewrite 2.0.0 d13.aarch64 pgdg 70.7 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-14-pg-rewrite 2.0.0 u22.x86_64 pgdg 89.4 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-14-pg-rewrite 2.0.0 u22.aarch64 pgdg 84.7 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-14-pg-rewrite 2.0.0 u24.x86_64 pgdg 75.5 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-14-pg-rewrite 2.0.0 u24.aarch64 pgdg 70.7 KiB postgresql-14-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_rewrite_13 2.0.0 el8.x86_64 pgdg 36.8 KiB pg_rewrite_13-2.0.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_13 1.1.0 el8.x86_64 pgdg 35.4 KiB pg_rewrite_13-1.1.0-1PGDG.rhel8.x86_64.rpm
pg_rewrite_13 2.0.0 el8.aarch64 pgdg 34.9 KiB pg_rewrite_13-2.0.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_13 1.1.0 el8.aarch64 pgdg 33.8 KiB pg_rewrite_13-1.1.0-1PGDG.rhel8.aarch64.rpm
pg_rewrite_13 2.0.0 el9.x86_64 pgdg 37.9 KiB pg_rewrite_13-2.0.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_13 1.1.0 el9.x86_64 pgdg 36.3 KiB pg_rewrite_13-1.1.0-1PGDG.rhel9.x86_64.rpm
pg_rewrite_13 2.0.0 el9.aarch64 pgdg 36.3 KiB pg_rewrite_13-2.0.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_13 1.1.0 el9.aarch64 pgdg 34.8 KiB pg_rewrite_13-1.1.0-1PGDG.rhel9.aarch64.rpm
pg_rewrite_13 2.0.0 el10.x86_64 pgdg 38.7 KiB pg_rewrite_13-2.0.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_13 1.1.0 el10.x86_64 pgdg 37.2 KiB pg_rewrite_13-1.1.0-1PGDG.rhel10.x86_64.rpm
pg_rewrite_13 2.0.0 el10.aarch64 pgdg 37.1 KiB pg_rewrite_13-2.0.0-1PGDG.rhel10.aarch64.rpm
pg_rewrite_13 1.1.0 el10.aarch64 pgdg 36.1 KiB pg_rewrite_13-1.1.0-1PGDG.rhel10.aarch64.rpm
postgresql-13-pg-rewrite 2.0.0 d12.x86_64 pgdg 74.6 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg12+1_amd64.deb
postgresql-13-pg-rewrite 2.0.0 d12.aarch64 pgdg 70.3 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg12+1_arm64.deb
postgresql-13-pg-rewrite 2.0.0 d13.x86_64 pgdg 74.6 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg13+1_amd64.deb
postgresql-13-pg-rewrite 2.0.0 d13.aarch64 pgdg 70.3 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg13+1_arm64.deb
postgresql-13-pg-rewrite 2.0.0 u22.x86_64 pgdg 87.9 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg22.04+1_amd64.deb
postgresql-13-pg-rewrite 2.0.0 u22.aarch64 pgdg 83.2 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg22.04+1_arm64.deb
postgresql-13-pg-rewrite 2.0.0 u24.x86_64 pgdg 74.8 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg24.04+1_amd64.deb
postgresql-13-pg-rewrite 2.0.0 u24.aarch64 pgdg 70.2 KiB postgresql-13-pg-rewrite_2.0.0-2.pgdg24.04+1_arm64.deb

Source

Repository
github.com/cybertec-postgresql/pg_rewrite
 Source Tarball
pg_rewrite-REL2_0_0.tar.gz
 
pig build pkg pg_rewrite;		# build spec not ready

Install

Make sure PGDG repo available:

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

Install this extension with pig:

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

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

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_rewrite';

Create this extension with:

CREATE EXTENSION pg_rewrite;
Last updated on
pg_repackpg_squeeze