What is the postgresql equivalent to ora_hash

Asked Jun 02 '20 at 22:29

Active Jun 02 '20 at 22:29

Viewed 414 times

Is there any equivalent function in postgresql database for ora_hash function in Oracle.

I already tried the MD5 function in postgresql but the value is not same as Oracle.

asked Jun 02 '20 at 22:29

Raj

[`ora_hash`](https://docs.oracle.com/database/121/SQLRF/functions136.htm#SQLRF06313) does not define what hash algorithm it uses. Finding an equivalent would have to be by trial and error and could change from version to version. `ora_hash` produces a 32 bit digest, very small, so it's definitely not MD5 which is 128 bit. – Schwern Jun 02 '20 at 22:36

0 Answers0