hashtypes

sha1, md5 and other data types for PostgreSQL

Overview

Package	Version	Category	License	Language
`hashtypes`	`0.1.5`	TYPE	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
3750	`hashtypes`	No	Yes	No	Yes	No	No	-

Related	`pgcrypto` `md5hash` `hashlib` `xxhash` `pgsodium` `shacrypt` `cryptint` `pguecc`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.1.5`	1817161514	`hashtypes`	-
RPM	PIGSTY	`0.1.5`	1817161514	`hashtypes_$v`	-
DEB	PIGSTY	`0.1.5`	1817161514	`postgresql-$v-hashtypes`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.1.5 el8.x86_64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.5 · 26.0KiB	PIGSTY 0.1.5 el8.x86_64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.5 · 26.0KiB	PIGSTY 0.1.5 el8.x86_64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.5 · 26.0KiB	PIGSTY 0.1.5 el8.x86_64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.5 · 26.0KiB	PIGSTY 0.1.5 el8.x86_64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.5 · 26.0KiB
el8.aarch64	PIGSTY 0.1.5 el8.aarch64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.5 · 25.9KiB	PIGSTY 0.1.5 el8.aarch64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.5 · 25.9KiB	PIGSTY 0.1.5 el8.aarch64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.5 · 25.9KiB	PIGSTY 0.1.5 el8.aarch64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.5 · 25.9KiB	PIGSTY 0.1.5 el8.aarch64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.5 · 25.9KiB
el9.x86_64	PIGSTY 0.1.5 el9.x86_64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB	PIGSTY 0.1.5 el9.x86_64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB	PIGSTY 0.1.5 el9.x86_64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB	PIGSTY 0.1.5 el9.x86_64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.5 · 24.3KiB	PIGSTY 0.1.5 el9.x86_64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB
el9.aarch64	PIGSTY 0.1.5 el9.aarch64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.5 · 23.7KiB	PIGSTY 0.1.5 el9.aarch64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.5 · 23.7KiB	PIGSTY 0.1.5 el9.aarch64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.5 · 23.7KiB	PIGSTY 0.1.5 el9.aarch64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el9.aarch64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.5 · 24.0KiB
el10.x86_64	PIGSTY 0.1.5 el10.x86_64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.x86_64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.x86_64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.x86_64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB	PIGSTY 0.1.5 el10.x86_64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.5 · 24.2KiB
el10.aarch64	PIGSTY 0.1.5 el10.aarch64.pg18 : hashtypes_18 hashtypes_18-0.1.5-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.aarch64.pg17 : hashtypes_17 hashtypes_17-0.1.5-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.aarch64.pg16 : hashtypes_16 hashtypes_16-0.1.5-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.5 · 24.0KiB	PIGSTY 0.1.5 el10.aarch64.pg15 : hashtypes_15 hashtypes_15-0.1.5-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.5 · 24.2KiB	PIGSTY 0.1.5 el10.aarch64.pg14 : hashtypes_14 hashtypes_14-0.1.5-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.5 · 24.2KiB
d12.x86_64	PIGSTY 0.1.5 d12.x86_64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.x86_64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.x86_64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.x86_64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.x86_64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.5 · 33.5KiB
d12.aarch64	PIGSTY 0.1.5 d12.aarch64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.aarch64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.aarch64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.5 · 33.4KiB	PIGSTY 0.1.5 d12.aarch64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d12.aarch64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.5 · 33.4KiB
d13.x86_64	PIGSTY 0.1.5 d13.x86_64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d13.x86_64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.5 · 33.6KiB	PIGSTY 0.1.5 d13.x86_64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d13.x86_64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.5 · 33.6KiB	PIGSTY 0.1.5 d13.x86_64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1.5 · 33.6KiB
d13.aarch64	PIGSTY 0.1.5 d13.aarch64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.5 · 33.7KiB	PIGSTY 0.1.5 d13.aarch64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.5 · 33.6KiB	PIGSTY 0.1.5 d13.aarch64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.5 · 33.6KiB	PIGSTY 0.1.5 d13.aarch64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.5 · 33.5KiB	PIGSTY 0.1.5 d13.aarch64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1.5 · 33.4KiB
u22.x86_64	PIGSTY 0.1.5 u22.x86_64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.5 · 35.8KiB	PIGSTY 0.1.5 u22.x86_64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.5 · 36.4KiB	PIGSTY 0.1.5 u22.x86_64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.5 · 36.4KiB	PIGSTY 0.1.5 u22.x86_64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.5 · 36.7KiB	PIGSTY 0.1.5 u22.x86_64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1.5 · 36.7KiB
u22.aarch64	PIGSTY 0.1.5 u22.aarch64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.5 · 35.2KiB	PIGSTY 0.1.5 u22.aarch64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.5 · 35.9KiB	PIGSTY 0.1.5 u22.aarch64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.5 · 35.9KiB	PIGSTY 0.1.5 u22.aarch64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.5 · 36.1KiB	PIGSTY 0.1.5 u22.aarch64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1.5 · 36.0KiB
u24.x86_64	PIGSTY 0.1.5 u24.x86_64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.5 · 35.0KiB	PIGSTY 0.1.5 u24.x86_64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.5 · 35.0KiB	PIGSTY 0.1.5 u24.x86_64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.5 · 35.0KiB	PIGSTY 0.1.5 u24.x86_64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u24.x86_64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~noble_amd64.deb PIGSTY · 0.1.5 · 34.9KiB
u24.aarch64	PIGSTY 0.1.5 u24.aarch64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u24.aarch64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.5 · 35.2KiB	PIGSTY 0.1.5 u24.aarch64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.5 · 35.0KiB	PIGSTY 0.1.5 u24.aarch64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.5 · 35.0KiB	PIGSTY 0.1.5 u24.aarch64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~noble_arm64.deb PIGSTY · 0.1.5 · 35.0KiB
u26.x86_64	PIGSTY 0.1.5 u26.x86_64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1.5 · 34.9KiB	PIGSTY 0.1.5 u26.x86_64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1.5 · 34.9KiB	PIGSTY 0.1.5 u26.x86_64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1.5 · 34.8KiB	PIGSTY 0.1.5 u26.x86_64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1.5 · 34.7KiB	PIGSTY 0.1.5 u26.x86_64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1.5 · 34.7KiB
u26.aarch64	PIGSTY 0.1.5 u26.aarch64.pg18 : postgresql-18-hashtypes postgresql-18-hashtypes_0.1.5-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u26.aarch64.pg17 : postgresql-17-hashtypes postgresql-17-hashtypes_0.1.5-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u26.aarch64.pg16 : postgresql-16-hashtypes postgresql-16-hashtypes_0.1.5-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u26.aarch64.pg15 : postgresql-15-hashtypes postgresql-15-hashtypes_0.1.5-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1.5 · 35.1KiB	PIGSTY 0.1.5 u26.aarch64.pg14 : postgresql-14-hashtypes postgresql-14-hashtypes_0.1.5-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1.5 · 35.0KiB

Build

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

pig build pkg hashtypes         # build RPM / DEB packages

Install

You can install hashtypes 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 hashtypes;          # Install for current active PG version

pig

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

dnf

dnf install -y hashtypes_18       # PG 18
dnf install -y hashtypes_17       # PG 17
dnf install -y hashtypes_16       # PG 16
dnf install -y hashtypes_15       # PG 15
dnf install -y hashtypes_14       # PG 14

apt

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

Create Extension:

CREATE EXTENSION hashtypes;

Usage

hashtypes: hash and checksum data types (SHA, CRC32)

The hashtypes extension provides native data types for storing hash values and checksums in their binary representation, saving storage compared to text.

CREATE EXTENSION hashtypes;

Data Types

Type	Storage	Description
`sha1`	20 bytes	SHA-1 hash (160-bit)
`sha224`	28 bytes	SHA-224 hash (224-bit)
`sha256`	32 bytes	SHA-256 hash (256-bit)
`sha384`	48 bytes	SHA-384 hash (384-bit)
`sha512`	64 bytes	SHA-512 hash (512-bit)
`crc32`	4 bytes	CRC-32 checksum

Usage

CREATE TABLE objects (
    hash sha256 PRIMARY KEY,
    data bytea
);

INSERT INTO objects VALUES (
    'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855',
    '\x'
);

SELECT * FROM objects WHERE hash = 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855';

Operators

All types support comparison operators: =, <>, <, >, <=, >=.

Index Support

Btree and hash index operator classes are provided for all types.

Casts

All types support bidirectional casts to/from text and bytea.

hashtypes

Overview

Version

Build

Install

Usage

Data Types

Usage

Operators

Index Support

Casts

Was this page helpful?