Efficient hash data types for PostgreSQL

December 27, 2022 ยท View on GitHub

Custom data types to store SHA-1, SHA-2, MD5, CRC32, etc in PostgreSQL without the storage and computation overhead of bytea.

History

Originally developed as shatypes in 2009-2010 by Alvaro Herrera and Jim Nasby.

Updated by Andrey Popp and Andrew Pantyukhin in 2011-2012.

Maintaned by adjust since 2014.