HASHBYTES Function - SQL Server to PostgreSQL Migration

In SQL Server, the HASHBYTES function computes a binary hash of the input data using the specified algorithm (such as MD5, SHA1, SHA2_256, or SHA2_512).

In PostgreSQL, you can use the MD5, SHA256, SHA512 and other functions.

SQL Server:

  -- Get SHA-512 hash
  SELECT HASHBYTES('SHA2_512', 'abc');
  /* 0xDDAF35A193617ABACC417349AE2... */
 
  -- Get SHA-256 hash
  SELECT HASHBYTES('SHA2_256', 'abc');
  /* 0xBA7816BF8F01CFEA414140DE5DA... */
 
  -- Get MD5 hash
  SELECT HASHBYTES('MD5', 'abc');
  /* 0x900150983CD24FB0D6963F7D28E17F72 */

PostgreSQL:

  -- Get SHA-512 hash
  SELECT SHA512('abc');
  /* \xddaf35a193617abacc417349ae2... */
 
  -- Get SHA-256 hash
  SELECT SHA256('abc');
  /* \xba7816bf8f01cfea414140de5da... */
 
  -- Get MD5 hash
  SELECT MD5('abc');
  /* 900150983cd24fb0d6963f7d28e17f72 */

For more information, see SQL Server to PostgreSQL Migration.