uint

unsigned integer types

Overview

Package	Version	Category	License	Language
`pguint`	`1.20250815`	TYPE	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
3730	`uint`	No	Yes	No	Yes	No	Yes	-

Related	`uint128` `pgmp` `numeral` `unit` `pg_rational` `seg` `cube`

no pg14 for el8/el9 pgdg repo

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	MIXED	`1.20250815`	1817161514	`pguint`	-
RPM	PIGSTY	`1.20250815`	1817161514	`pguint_$v`	-
DEB	PIGSTY	`1.20250815`	1817161514	`postgresql-$v-pguint`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.20250815 el8.x86_64.pg18 : pguint_18 pguint_18-1.20250815-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.20250815 · 94.6KiB pguint_18-1.20250815-1PGDG.rhel8.x86_64.rpm PGDG · 1.20250815 · 72.4KiB	PIGSTY 1.20250815 el8.x86_64.pg17 : pguint_17 pguint_17-1.20250815-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.20250815 · 94.7KiB pguint_17-1.20250815-1PGDG.rhel8.x86_64.rpm PGDG · 1.20250815 · 72.4KiB pguint_17-1.20231206-2PGDG.rhel8.x86_64.rpm PGDG · 1.20231206 · 71.4KiB	PIGSTY 1.20250815 el8.x86_64.pg16 : pguint_16 pguint_16-1.20250815-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.20250815 · 94.7KiB pguint_16-1.20250815-1PGDG.rhel8.x86_64.rpm PGDG · 1.20250815 · 72.5KiB pguint_16-1.20231206-1PGDG.rhel8.x86_64.rpm PGDG · 1.20231206 · 71.3KiB pguint_16-1.20220601-3.rhel8.1.x86_64.rpm PGDG · 1.20220601 · 71.2KiB	PIGSTY 1.20250815 el8.x86_64.pg15 : pguint_15 pguint_15-1.20250815-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.20250815 · 94.6KiB pguint_15-1.20250815-1PGDG.rhel8.x86_64.rpm PGDG · 1.20250815 · 72.4KiB pguint_15-1.20231206-1PGDG.rhel8.x86_64.rpm PGDG · 1.20231206 · 71.2KiB	PIGSTY 1.20250815 el8.x86_64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.20250815 · 94.6KiB
el8.aarch64	PIGSTY 1.20250815 el8.aarch64.pg18 : pguint_18 pguint_18-1.20250815-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.20250815 · 82.9KiB pguint_18-1.20250815-1PGDG.rhel8.aarch64.rpm PGDG · 1.20250815 · 66.5KiB	PIGSTY 1.20250815 el8.aarch64.pg17 : pguint_17 pguint_17-1.20250815-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.20250815 · 82.7KiB pguint_17-1.20250815-1PGDG.rhel8.aarch64.rpm PGDG · 1.20250815 · 66.5KiB pguint_17-1.20231206-2PGDG.rhel8.aarch64.rpm PGDG · 1.20231206 · 65.4KiB	PIGSTY 1.20250815 el8.aarch64.pg16 : pguint_16 pguint_16-1.20250815-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.20250815 · 82.8KiB pguint_16-1.20250815-1PGDG.rhel8.aarch64.rpm PGDG · 1.20250815 · 66.5KiB pguint_16-1.20231206-1PGDG.rhel8.aarch64.rpm PGDG · 1.20231206 · 65.3KiB pguint_16-1.20220601-3.rhel8.1.aarch64.rpm PGDG · 1.20220601 · 64.9KiB	PIGSTY 1.20250815 el8.aarch64.pg15 : pguint_15 pguint_15-1.20250815-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.20250815 · 82.8KiB pguint_15-1.20250815-1PGDG.rhel8.aarch64.rpm PGDG · 1.20250815 · 66.4KiB pguint_15-1.20231206-1PGDG.rhel8.aarch64.rpm PGDG · 1.20231206 · 65.3KiB	PIGSTY 1.20250815 el8.aarch64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.20250815 · 82.6KiB
el9.x86_64	PGDG 1.20250815 el9.x86_64.pg18 : pguint_18 pguint_18-1.20250815-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.20250815 · 75.9KiB pguint_18-1.20250815-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.20250815 · 82.4KiB pguint_18-1.20250815-1PGDG.rhel9.x86_64.rpm PGDG · 1.20250815 · 75.8KiB	PGDG 1.20250815 el9.x86_64.pg17 : pguint_17 pguint_17-1.20250815-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.20250815 · 75.9KiB pguint_17-1.20250815-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.20250815 · 83.1KiB pguint_17-1.20250815-1PGDG.rhel9.x86_64.rpm PGDG · 1.20250815 · 75.7KiB pguint_17-1.20231206-2PGDG.rhel9.x86_64.rpm PGDG · 1.20231206 · 74.9KiB	PGDG 1.20250815 el9.x86_64.pg16 : pguint_16 pguint_16-1.20250815-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.20250815 · 75.9KiB pguint_16-1.20250815-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.20250815 · 83.0KiB pguint_16-1.20250815-1PGDG.rhel9.x86_64.rpm PGDG · 1.20250815 · 75.7KiB pguint_16-1.20231206-1PGDG.rhel9.x86_64.rpm PGDG · 1.20231206 · 74.8KiB pguint_16-1.20220601-3.rhel9.1.x86_64.rpm PGDG · 1.20220601 · 74.5KiB	PGDG 1.20250815 el9.x86_64.pg15 : pguint_15 pguint_15-1.20250815-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.20250815 · 75.8KiB pguint_15-1.20250815-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.20250815 · 83.0KiB pguint_15-1.20250815-1PGDG.rhel9.x86_64.rpm PGDG · 1.20250815 · 75.6KiB pguint_15-1.20231206-1PGDG.rhel9.x86_64.rpm PGDG · 1.20231206 · 74.8KiB	PIGSTY 1.20250815 el9.x86_64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.20250815 · 82.9KiB
el9.aarch64	PGDG 1.20250815 el9.aarch64.pg18 : pguint_18 pguint_18-1.20250815-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.20250815 · 70.4KiB pguint_18-1.20250815-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.20250815 · 77.4KiB pguint_18-1.20250815-1PGDG.rhel9.aarch64.rpm PGDG · 1.20250815 · 70.2KiB	PGDG 1.20250815 el9.aarch64.pg17 : pguint_17 pguint_17-1.20250815-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.20250815 · 70.4KiB pguint_17-1.20250815-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.20250815 · 77.5KiB pguint_17-1.20250815-1PGDG.rhel9.aarch64.rpm PGDG · 1.20250815 · 70.3KiB pguint_17-1.20231206-2PGDG.rhel9.aarch64.rpm PGDG · 1.20231206 · 69.6KiB	PGDG 1.20250815 el9.aarch64.pg16 : pguint_16 pguint_16-1.20250815-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.20250815 · 70.5KiB pguint_16-1.20250815-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.20250815 · 77.5KiB pguint_16-1.20250815-1PGDG.rhel9.aarch64.rpm PGDG · 1.20250815 · 70.4KiB pguint_16-1.20231206-1PGDG.rhel9.aarch64.rpm PGDG · 1.20231206 · 69.6KiB pguint_16-1.20220601-3.rhel9.1.aarch64.rpm PGDG · 1.20220601 · 69.1KiB	PGDG 1.20250815 el9.aarch64.pg15 : pguint_15 pguint_15-1.20250815-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.20250815 · 70.6KiB pguint_15-1.20250815-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.20250815 · 77.1KiB pguint_15-1.20250815-1PGDG.rhel9.aarch64.rpm PGDG · 1.20250815 · 70.4KiB pguint_15-1.20231206-1PGDG.rhel9.aarch64.rpm PGDG · 1.20231206 · 69.4KiB	PIGSTY 1.20250815 el9.aarch64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.20250815 · 77.1KiB
el10.x86_64	PGDG 1.20250815 el10.x86_64.pg18 : pguint_18 pguint_18-1.20250815-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.20250815 · 75.6KiB pguint_18-1.20250815-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.20250815 · 82.6KiB pguint_18-1.20250815-1PGDG.rhel10.x86_64.rpm PGDG · 1.20250815 · 75.9KiB	PGDG 1.20250815 el10.x86_64.pg17 : pguint_17 pguint_17-1.20250815-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.20250815 · 75.4KiB pguint_17-1.20250815-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.20250815 · 82.4KiB pguint_17-1.20250815-1PGDG.rhel10.x86_64.rpm PGDG · 1.20250815 · 75.8KiB pguint_17-1.20231206-3PGDG.rhel10.x86_64.rpm PGDG · 1.20231206 · 75.5KiB	PGDG 1.20250815 el10.x86_64.pg16 : pguint_16 pguint_16-1.20250815-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.20250815 · 75.4KiB pguint_16-1.20250815-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.20250815 · 82.4KiB pguint_16-1.20250815-1PGDG.rhel10.x86_64.rpm PGDG · 1.20250815 · 76.2KiB pguint_16-1.20231206-3PGDG.rhel10.x86_64.rpm PGDG · 1.20231206 · 75.5KiB	PGDG 1.20250815 el10.x86_64.pg15 : pguint_15 pguint_15-1.20250815-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.20250815 · 75.4KiB pguint_15-1.20250815-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.20250815 · 82.5KiB pguint_15-1.20250815-1PGDG.rhel10.x86_64.rpm PGDG · 1.20250815 · 75.8KiB pguint_15-1.20231206-3PGDG.rhel10.x86_64.rpm PGDG · 1.20231206 · 75.9KiB	PIGSTY 1.20250815 el10.x86_64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.20250815 · 82.4KiB
el10.aarch64	PGDG 1.20250815 el10.aarch64.pg18 : pguint_18 pguint_18-1.20250815-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.20250815 · 71.7KiB pguint_18-1.20250815-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.20250815 · 78.5KiB pguint_18-1.20250815-1PGDG.rhel10.aarch64.rpm PGDG · 1.20250815 · 72.1KiB	PGDG 1.20250815 el10.aarch64.pg17 : pguint_17 pguint_17-1.20250815-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.20250815 · 71.7KiB pguint_17-1.20250815-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.20250815 · 78.0KiB pguint_17-1.20250815-1PGDG.rhel10.aarch64.rpm PGDG · 1.20250815 · 72.1KiB pguint_17-1.20231206-3PGDG.rhel10.aarch64.rpm PGDG · 1.20231206 · 72.1KiB	PGDG 1.20250815 el10.aarch64.pg16 : pguint_16 pguint_16-1.20250815-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.20250815 · 72.2KiB pguint_16-1.20250815-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.20250815 · 77.1KiB pguint_16-1.20250815-1PGDG.rhel10.aarch64.rpm PGDG · 1.20250815 · 72.4KiB pguint_16-1.20231206-3PGDG.rhel10.aarch64.rpm PGDG · 1.20231206 · 72.1KiB	PGDG 1.20250815 el10.aarch64.pg15 : pguint_15 pguint_15-1.20250815-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.20250815 · 71.3KiB pguint_15-1.20250815-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.20250815 · 78.0KiB pguint_15-1.20250815-1PGDG.rhel10.aarch64.rpm PGDG · 1.20250815 · 72.3KiB pguint_15-1.20231206-3PGDG.rhel10.aarch64.rpm PGDG · 1.20231206 · 71.7KiB	PIGSTY 1.20250815 el10.aarch64.pg14 : pguint_14 pguint_14-1.20250815-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.20250815 · 77.1KiB
d12.x86_64	PIGSTY 1.20250815 d12.x86_64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.20250815 · 159.9KiB	PIGSTY 1.20250815 d12.x86_64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.20250815 · 159.9KiB	PIGSTY 1.20250815 d12.x86_64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.20250815 · 159.8KiB	PIGSTY 1.20250815 d12.x86_64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.20250815 · 161.1KiB	PIGSTY 1.20250815 d12.x86_64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.20250815 · 160.5KiB
d12.aarch64	PIGSTY 1.20250815 d12.aarch64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.20250815 · 156.1KiB	PIGSTY 1.20250815 d12.aarch64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.20250815 · 156.2KiB	PIGSTY 1.20250815 d12.aarch64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.20250815 · 155.6KiB	PIGSTY 1.20250815 d12.aarch64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.20250815 · 157.3KiB	PIGSTY 1.20250815 d12.aarch64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.20250815 · 156.4KiB
d13.x86_64	PIGSTY 1.20250815 d13.x86_64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~trixie_amd64.deb PIGSTY · 1.20250815 · 159.6KiB	PIGSTY 1.20250815 d13.x86_64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~trixie_amd64.deb PIGSTY · 1.20250815 · 158.6KiB	PIGSTY 1.20250815 d13.x86_64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~trixie_amd64.deb PIGSTY · 1.20250815 · 159.5KiB	PIGSTY 1.20250815 d13.x86_64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~trixie_amd64.deb PIGSTY · 1.20250815 · 160.3KiB	PIGSTY 1.20250815 d13.x86_64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~trixie_amd64.deb PIGSTY · 1.20250815 · 159.6KiB
d13.aarch64	PIGSTY 1.20250815 d13.aarch64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~trixie_arm64.deb PIGSTY · 1.20250815 · 156.3KiB	PIGSTY 1.20250815 d13.aarch64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~trixie_arm64.deb PIGSTY · 1.20250815 · 156.0KiB	PIGSTY 1.20250815 d13.aarch64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~trixie_arm64.deb PIGSTY · 1.20250815 · 155.9KiB	PIGSTY 1.20250815 d13.aarch64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~trixie_arm64.deb PIGSTY · 1.20250815 · 157.5KiB	PIGSTY 1.20250815 d13.aarch64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~trixie_arm64.deb PIGSTY · 1.20250815 · 156.4KiB
u22.x86_64	PIGSTY 1.20250815 u22.x86_64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~jammy_amd64.deb PIGSTY · 1.20250815 · 190.2KiB	PIGSTY 1.20250815 u22.x86_64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~jammy_amd64.deb PIGSTY · 1.20250815 · 193.1KiB	PIGSTY 1.20250815 u22.x86_64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~jammy_amd64.deb PIGSTY · 1.20250815 · 193.1KiB	PIGSTY 1.20250815 u22.x86_64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~jammy_amd64.deb PIGSTY · 1.20250815 · 192.3KiB	PIGSTY 1.20250815 u22.x86_64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~jammy_amd64.deb PIGSTY · 1.20250815 · 192.3KiB
u22.aarch64	PIGSTY 1.20250815 u22.aarch64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~jammy_arm64.deb PIGSTY · 1.20250815 · 185.6KiB	PIGSTY 1.20250815 u22.aarch64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~jammy_arm64.deb PIGSTY · 1.20250815 · 188.5KiB	PIGSTY 1.20250815 u22.aarch64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~jammy_arm64.deb PIGSTY · 1.20250815 · 188.4KiB	PIGSTY 1.20250815 u22.aarch64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~jammy_arm64.deb PIGSTY · 1.20250815 · 187.5KiB	PIGSTY 1.20250815 u22.aarch64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~jammy_arm64.deb PIGSTY · 1.20250815 · 187.5KiB
u24.x86_64	PIGSTY 1.20250815 u24.x86_64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~noble_amd64.deb PIGSTY · 1.20250815 · 177.9KiB	PIGSTY 1.20250815 u24.x86_64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~noble_amd64.deb PIGSTY · 1.20250815 · 177.7KiB	PIGSTY 1.20250815 u24.x86_64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~noble_amd64.deb PIGSTY · 1.20250815 · 177.8KiB	PIGSTY 1.20250815 u24.x86_64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~noble_amd64.deb PIGSTY · 1.20250815 · 178.4KiB	PIGSTY 1.20250815 u24.x86_64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~noble_amd64.deb PIGSTY · 1.20250815 · 178.5KiB
u24.aarch64	PIGSTY 1.20250815 u24.aarch64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~noble_arm64.deb PIGSTY · 1.20250815 · 175.4KiB	PIGSTY 1.20250815 u24.aarch64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~noble_arm64.deb PIGSTY · 1.20250815 · 175.5KiB	PIGSTY 1.20250815 u24.aarch64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~noble_arm64.deb PIGSTY · 1.20250815 · 175.5KiB	PIGSTY 1.20250815 u24.aarch64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~noble_arm64.deb PIGSTY · 1.20250815 · 176.2KiB	PIGSTY 1.20250815 u24.aarch64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~noble_arm64.deb PIGSTY · 1.20250815 · 148.8KiB
u26.x86_64	PIGSTY 1.20250815 u26.x86_64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~resolute_amd64.deb PIGSTY · 1.20250815 · 179.1KiB	PIGSTY 1.20250815 u26.x86_64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~resolute_amd64.deb PIGSTY · 1.20250815 · 179.2KiB	PIGSTY 1.20250815 u26.x86_64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~resolute_amd64.deb PIGSTY · 1.20250815 · 179.2KiB	PIGSTY 1.20250815 u26.x86_64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~resolute_amd64.deb PIGSTY · 1.20250815 · 178.4KiB	PIGSTY 1.20250815 u26.x86_64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~resolute_amd64.deb PIGSTY · 1.20250815 · 178.5KiB
u26.aarch64	PIGSTY 1.20250815 u26.aarch64.pg18 : postgresql-18-pguint postgresql-18-pguint_1.20250815-1PIGSTY~resolute_arm64.deb PIGSTY · 1.20250815 · 177.7KiB	PIGSTY 1.20250815 u26.aarch64.pg17 : postgresql-17-pguint postgresql-17-pguint_1.20250815-1PIGSTY~resolute_arm64.deb PIGSTY · 1.20250815 · 177.6KiB	PIGSTY 1.20250815 u26.aarch64.pg16 : postgresql-16-pguint postgresql-16-pguint_1.20250815-1PIGSTY~resolute_arm64.deb PIGSTY · 1.20250815 · 177.7KiB	PIGSTY 1.20250815 u26.aarch64.pg15 : postgresql-15-pguint postgresql-15-pguint_1.20250815-1PIGSTY~resolute_arm64.deb PIGSTY · 1.20250815 · 177.2KiB	PIGSTY 1.20250815 u26.aarch64.pg14 : postgresql-14-pguint postgresql-14-pguint_1.20250815-1PIGSTY~resolute_arm64.deb PIGSTY · 1.20250815 · 177.4KiB

Build

You can build the RPM / DEB packages for pguint using pig build:

pig build pkg pguint         # build RPM / DEB packages

Install

You can install pguint directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

Install

pig install pguint;          # Install for current active PG version

pig

pig ext install -y pguint -v 18  # PG 18
pig ext install -y pguint -v 17  # PG 17
pig ext install -y pguint -v 16  # PG 16
pig ext install -y pguint -v 15  # PG 15
pig ext install -y pguint -v 14  # PG 14

dnf

dnf install -y pguint_18       # PG 18
dnf install -y pguint_17       # PG 17
dnf install -y pguint_16       # PG 16
dnf install -y pguint_15       # PG 15
dnf install -y pguint_14       # PG 14

apt

apt install -y postgresql-18-pguint   # PG 18
apt install -y postgresql-17-pguint   # PG 17
apt install -y postgresql-16-pguint   # PG 16
apt install -y postgresql-15-pguint   # PG 15
apt install -y postgresql-14-pguint   # PG 14

Create Extension:

CREATE EXTENSION uint;

Usage

uint: unsigned integer types for PostgreSQL

The uint extension adds unsigned and small integer types to PostgreSQL.

CREATE EXTENSION uint;

Data Types

Type	Description	Range
`int1`	Signed 8-bit integer	-128 to 127
`uint1`	Unsigned 8-bit integer	0 to 255
`uint2`	Unsigned 16-bit integer	0 to 65535
`uint4`	Unsigned 32-bit integer	0 to 4294967295
`uint8`	Unsigned 64-bit integer	0 to 18446744073709551615

Usage

CREATE TABLE foo (
    a uint4,
    b text
);

SELECT * FROM foo WHERE a > 4;
SELECT avg(a) FROM foo;

Operators and Functions

All types include a full set of arithmetic operators (+, -, *, /, %), comparison operators (=, <>, <, >, <=, >=), and operators for each combination of types. Standard aggregate functions and index support (btree, hash) are also provided.

uint

Overview

Version

Build

Install

Usage

Data Types

Usage

Operators and Functions

Was this page helpful?