uint

pguint : unsigned integer types

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
3730
uint
pguint
1.20250815
TYPE
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap

no pg14 for el8/el9 pgdg repo

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
MIXED
1.20250815
18
17
16
15
14
pguint-
RPM
PIGSTY
1.20250815
18
17
16
15
14
pguint_$v-
DEB
PIGSTY
1.20250815
18
17
16
15
14
postgresql-$v-pguint-
Linux / PGPG18PG17PG16PG15PG14
el8.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
el8.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
el9.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
el9.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
el10.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
el10.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
d12.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
d12.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
d13.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
d13.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
u22.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
u22.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
u24.x86_64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
u24.aarch64
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PIGSTY 1.20250815
PackageVersionOSORGSIZEFile URL
pguint_181.20250815el8.x86_64pigsty94.6 KiBpguint_18-1.20250815-1PIGSTY.el8.x86_64.rpm
pguint_181.20250815el8.x86_64pgdg72.4 KiBpguint_18-1.20250815-1PGDG.rhel8.x86_64.rpm
pguint_181.20250815el8.aarch64pigsty82.9 KiBpguint_18-1.20250815-1PIGSTY.el8.aarch64.rpm
pguint_181.20250815el8.aarch64pgdg66.5 KiBpguint_18-1.20250815-1PGDG.rhel8.aarch64.rpm
pguint_181.20250815el9.x86_64pigsty82.4 KiBpguint_18-1.20250815-1PIGSTY.el9.x86_64.rpm
pguint_181.20250815el9.x86_64pgdg75.8 KiBpguint_18-1.20250815-1PGDG.rhel9.x86_64.rpm
pguint_181.20250815el9.aarch64pigsty77.4 KiBpguint_18-1.20250815-1PIGSTY.el9.aarch64.rpm
pguint_181.20250815el9.aarch64pgdg70.2 KiBpguint_18-1.20250815-1PGDG.rhel9.aarch64.rpm
pguint_181.20250815el10.x86_64pigsty82.6 KiBpguint_18-1.20250815-1PIGSTY.el10.x86_64.rpm
pguint_181.20250815el10.x86_64pgdg75.9 KiBpguint_18-1.20250815-1PGDG.rhel10.x86_64.rpm
pguint_181.20250815el10.aarch64pigsty78.5 KiBpguint_18-1.20250815-1PIGSTY.el10.aarch64.rpm
pguint_181.20250815el10.aarch64pgdg72.1 KiBpguint_18-1.20250815-1PGDG.rhel10.aarch64.rpm
postgresql-18-pguint1.20250815d12.x86_64pigsty159.9 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb
postgresql-18-pguint1.20250815d12.aarch64pigsty156.1 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb
postgresql-18-pguint1.20250815d13.x86_64pigsty159.6 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~trixie_amd64.deb
postgresql-18-pguint1.20250815d13.aarch64pigsty156.3 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~trixie_arm64.deb
postgresql-18-pguint1.20250815u22.x86_64pigsty190.2 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~jammy_amd64.deb
postgresql-18-pguint1.20250815u22.aarch64pigsty185.6 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~jammy_arm64.deb
postgresql-18-pguint1.20250815u24.x86_64pigsty177.9 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~noble_amd64.deb
postgresql-18-pguint1.20250815u24.aarch64pigsty175.4 KiBpostgresql-18-pguint_1.20250815-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pguint_171.20250815el8.x86_64pigsty94.7 KiBpguint_17-1.20250815-1PIGSTY.el8.x86_64.rpm
pguint_171.20250815el8.x86_64pgdg72.4 KiBpguint_17-1.20250815-1PGDG.rhel8.x86_64.rpm
pguint_171.20231206el8.x86_64pgdg71.4 KiBpguint_17-1.20231206-2PGDG.rhel8.x86_64.rpm
pguint_171.20250815el8.aarch64pigsty82.7 KiBpguint_17-1.20250815-1PIGSTY.el8.aarch64.rpm
pguint_171.20250815el8.aarch64pgdg66.5 KiBpguint_17-1.20250815-1PGDG.rhel8.aarch64.rpm
pguint_171.20231206el8.aarch64pgdg65.4 KiBpguint_17-1.20231206-2PGDG.rhel8.aarch64.rpm
pguint_171.20250815el9.x86_64pigsty83.1 KiBpguint_17-1.20250815-1PIGSTY.el9.x86_64.rpm
pguint_171.20250815el9.x86_64pgdg75.7 KiBpguint_17-1.20250815-1PGDG.rhel9.x86_64.rpm
pguint_171.20231206el9.x86_64pgdg74.9 KiBpguint_17-1.20231206-2PGDG.rhel9.x86_64.rpm
pguint_171.20250815el9.aarch64pigsty77.5 KiBpguint_17-1.20250815-1PIGSTY.el9.aarch64.rpm
pguint_171.20250815el9.aarch64pgdg70.3 KiBpguint_17-1.20250815-1PGDG.rhel9.aarch64.rpm
pguint_171.20231206el9.aarch64pgdg69.6 KiBpguint_17-1.20231206-2PGDG.rhel9.aarch64.rpm
pguint_171.20250815el10.x86_64pigsty82.4 KiBpguint_17-1.20250815-1PIGSTY.el10.x86_64.rpm
pguint_171.20250815el10.x86_64pgdg75.8 KiBpguint_17-1.20250815-1PGDG.rhel10.x86_64.rpm
pguint_171.20231206el10.x86_64pgdg75.5 KiBpguint_17-1.20231206-3PGDG.rhel10.x86_64.rpm
pguint_171.20250815el10.aarch64pigsty78.0 KiBpguint_17-1.20250815-1PIGSTY.el10.aarch64.rpm
pguint_171.20250815el10.aarch64pgdg72.1 KiBpguint_17-1.20250815-1PGDG.rhel10.aarch64.rpm
pguint_171.20231206el10.aarch64pgdg72.1 KiBpguint_17-1.20231206-3PGDG.rhel10.aarch64.rpm
postgresql-17-pguint1.20250815d12.x86_64pigsty159.9 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb
postgresql-17-pguint1.20250815d12.aarch64pigsty156.2 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb
postgresql-17-pguint1.20250815d13.x86_64pigsty158.6 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~trixie_amd64.deb
postgresql-17-pguint1.20250815d13.aarch64pigsty156.0 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~trixie_arm64.deb
postgresql-17-pguint1.20250815u22.x86_64pigsty193.1 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~jammy_amd64.deb
postgresql-17-pguint1.20250815u22.aarch64pigsty188.5 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~jammy_arm64.deb
postgresql-17-pguint1.20250815u24.x86_64pigsty177.7 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~noble_amd64.deb
postgresql-17-pguint1.20250815u24.aarch64pigsty175.5 KiBpostgresql-17-pguint_1.20250815-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pguint_161.20250815el8.x86_64pigsty94.7 KiBpguint_16-1.20250815-1PIGSTY.el8.x86_64.rpm
pguint_161.20250815el8.x86_64pgdg72.5 KiBpguint_16-1.20250815-1PGDG.rhel8.x86_64.rpm
pguint_161.20231206el8.x86_64pgdg71.3 KiBpguint_16-1.20231206-1PGDG.rhel8.x86_64.rpm
pguint_161.20220601el8.x86_64pgdg71.2 KiBpguint_16-1.20220601-3.rhel8.1.x86_64.rpm
pguint_161.20250815el8.aarch64pigsty82.8 KiBpguint_16-1.20250815-1PIGSTY.el8.aarch64.rpm
pguint_161.20250815el8.aarch64pgdg66.5 KiBpguint_16-1.20250815-1PGDG.rhel8.aarch64.rpm
pguint_161.20231206el8.aarch64pgdg65.3 KiBpguint_16-1.20231206-1PGDG.rhel8.aarch64.rpm
pguint_161.20220601el8.aarch64pgdg64.9 KiBpguint_16-1.20220601-3.rhel8.1.aarch64.rpm
pguint_161.20250815el9.x86_64pigsty83.0 KiBpguint_16-1.20250815-1PIGSTY.el9.x86_64.rpm
pguint_161.20250815el9.x86_64pgdg75.7 KiBpguint_16-1.20250815-1PGDG.rhel9.x86_64.rpm
pguint_161.20231206el9.x86_64pgdg74.8 KiBpguint_16-1.20231206-1PGDG.rhel9.x86_64.rpm
pguint_161.20220601el9.x86_64pgdg74.5 KiBpguint_16-1.20220601-3.rhel9.1.x86_64.rpm
pguint_161.20250815el9.aarch64pigsty77.5 KiBpguint_16-1.20250815-1PIGSTY.el9.aarch64.rpm
pguint_161.20250815el9.aarch64pgdg70.4 KiBpguint_16-1.20250815-1PGDG.rhel9.aarch64.rpm
pguint_161.20231206el9.aarch64pgdg69.6 KiBpguint_16-1.20231206-1PGDG.rhel9.aarch64.rpm
pguint_161.20220601el9.aarch64pgdg69.1 KiBpguint_16-1.20220601-3.rhel9.1.aarch64.rpm
pguint_161.20250815el10.x86_64pigsty82.4 KiBpguint_16-1.20250815-1PIGSTY.el10.x86_64.rpm
pguint_161.20250815el10.x86_64pgdg76.2 KiBpguint_16-1.20250815-1PGDG.rhel10.x86_64.rpm
pguint_161.20231206el10.x86_64pgdg75.5 KiBpguint_16-1.20231206-3PGDG.rhel10.x86_64.rpm
pguint_161.20250815el10.aarch64pigsty77.1 KiBpguint_16-1.20250815-1PIGSTY.el10.aarch64.rpm
pguint_161.20250815el10.aarch64pgdg72.4 KiBpguint_16-1.20250815-1PGDG.rhel10.aarch64.rpm
pguint_161.20231206el10.aarch64pgdg72.1 KiBpguint_16-1.20231206-3PGDG.rhel10.aarch64.rpm
postgresql-16-pguint1.20250815d12.x86_64pigsty159.8 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb
postgresql-16-pguint1.20250815d12.aarch64pigsty155.6 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb
postgresql-16-pguint1.20250815d13.x86_64pigsty159.5 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~trixie_amd64.deb
postgresql-16-pguint1.20250815d13.aarch64pigsty155.9 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~trixie_arm64.deb
postgresql-16-pguint1.20250815u22.x86_64pigsty193.1 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~jammy_amd64.deb
postgresql-16-pguint1.20250815u22.aarch64pigsty188.4 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~jammy_arm64.deb
postgresql-16-pguint1.20250815u24.x86_64pigsty177.8 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~noble_amd64.deb
postgresql-16-pguint1.20250815u24.aarch64pigsty175.5 KiBpostgresql-16-pguint_1.20250815-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pguint_151.20250815el8.x86_64pigsty94.6 KiBpguint_15-1.20250815-1PIGSTY.el8.x86_64.rpm
pguint_151.20250815el8.x86_64pgdg72.4 KiBpguint_15-1.20250815-1PGDG.rhel8.x86_64.rpm
pguint_151.20231206el8.x86_64pgdg71.2 KiBpguint_15-1.20231206-1PGDG.rhel8.x86_64.rpm
pguint_151.20250815el8.aarch64pigsty82.8 KiBpguint_15-1.20250815-1PIGSTY.el8.aarch64.rpm
pguint_151.20250815el8.aarch64pgdg66.4 KiBpguint_15-1.20250815-1PGDG.rhel8.aarch64.rpm
pguint_151.20231206el8.aarch64pgdg65.3 KiBpguint_15-1.20231206-1PGDG.rhel8.aarch64.rpm
pguint_151.20250815el9.x86_64pigsty83.0 KiBpguint_15-1.20250815-1PIGSTY.el9.x86_64.rpm
pguint_151.20250815el9.x86_64pgdg75.6 KiBpguint_15-1.20250815-1PGDG.rhel9.x86_64.rpm
pguint_151.20231206el9.x86_64pgdg74.8 KiBpguint_15-1.20231206-1PGDG.rhel9.x86_64.rpm
pguint_151.20250815el9.aarch64pigsty77.1 KiBpguint_15-1.20250815-1PIGSTY.el9.aarch64.rpm
pguint_151.20250815el9.aarch64pgdg70.4 KiBpguint_15-1.20250815-1PGDG.rhel9.aarch64.rpm
pguint_151.20231206el9.aarch64pgdg69.4 KiBpguint_15-1.20231206-1PGDG.rhel9.aarch64.rpm
pguint_151.20250815el10.x86_64pigsty82.5 KiBpguint_15-1.20250815-1PIGSTY.el10.x86_64.rpm
pguint_151.20250815el10.x86_64pgdg75.8 KiBpguint_15-1.20250815-1PGDG.rhel10.x86_64.rpm
pguint_151.20231206el10.x86_64pgdg75.9 KiBpguint_15-1.20231206-3PGDG.rhel10.x86_64.rpm
pguint_151.20250815el10.aarch64pigsty78.0 KiBpguint_15-1.20250815-1PIGSTY.el10.aarch64.rpm
pguint_151.20250815el10.aarch64pgdg72.3 KiBpguint_15-1.20250815-1PGDG.rhel10.aarch64.rpm
pguint_151.20231206el10.aarch64pgdg71.7 KiBpguint_15-1.20231206-3PGDG.rhel10.aarch64.rpm
postgresql-15-pguint1.20250815d12.x86_64pigsty161.1 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb
postgresql-15-pguint1.20250815d12.aarch64pigsty157.3 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb
postgresql-15-pguint1.20250815d13.x86_64pigsty160.3 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~trixie_amd64.deb
postgresql-15-pguint1.20250815d13.aarch64pigsty157.5 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~trixie_arm64.deb
postgresql-15-pguint1.20250815u22.x86_64pigsty192.3 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~jammy_amd64.deb
postgresql-15-pguint1.20250815u22.aarch64pigsty187.5 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~jammy_arm64.deb
postgresql-15-pguint1.20250815u24.x86_64pigsty178.4 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~noble_amd64.deb
postgresql-15-pguint1.20250815u24.aarch64pigsty176.2 KiBpostgresql-15-pguint_1.20250815-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pguint_141.20250815el8.x86_64pigsty94.6 KiBpguint_14-1.20250815-1PIGSTY.el8.x86_64.rpm
pguint_141.20250815el8.aarch64pigsty82.6 KiBpguint_14-1.20250815-1PIGSTY.el8.aarch64.rpm
pguint_141.20250815el9.x86_64pigsty82.9 KiBpguint_14-1.20250815-1PIGSTY.el9.x86_64.rpm
pguint_141.20250815el9.aarch64pigsty77.1 KiBpguint_14-1.20250815-1PIGSTY.el9.aarch64.rpm
pguint_141.20250815el10.x86_64pigsty82.4 KiBpguint_14-1.20250815-1PIGSTY.el10.x86_64.rpm
pguint_141.20250815el10.aarch64pigsty77.1 KiBpguint_14-1.20250815-1PIGSTY.el10.aarch64.rpm
postgresql-14-pguint1.20250815d12.x86_64pigsty160.5 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~bookworm_amd64.deb
postgresql-14-pguint1.20250815d12.aarch64pigsty156.4 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~bookworm_arm64.deb
postgresql-14-pguint1.20250815d13.x86_64pigsty159.6 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~trixie_amd64.deb
postgresql-14-pguint1.20250815d13.aarch64pigsty156.4 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~trixie_arm64.deb
postgresql-14-pguint1.20250815u22.x86_64pigsty192.3 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~jammy_amd64.deb
postgresql-14-pguint1.20250815u22.aarch64pigsty187.5 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~jammy_arm64.deb
postgresql-14-pguint1.20250815u24.x86_64pigsty178.5 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~noble_amd64.deb
postgresql-14-pguint1.20250815u24.aarch64pigsty148.8 KiBpostgresql-14-pguint_1.20250815-1PIGSTY~noble_arm64.deb

Source

pig build pkg pguint;		# 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 pguint;		# install via package name, for the active PG version
pig install uint;		# install by extension name, for the current active PG version

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

Create this extension with:

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

TypeDescriptionRange
int1Signed 8-bit integer-128 to 127
uint1Unsigned 8-bit integer0 to 255
uint2Unsigned 16-bit integer0 to 65535
uint4Unsigned 32-bit integer0 to 4294967295
uint8Unsigned 64-bit integer0 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.

Last updated on