2

We use oracle built in function - outln_edit_pkg.generate_signature - to generate 32 byte hash signature for up to a 32k-1 sized string value passed to it.
Reference:

Wondering what would be the replacement when we move to Postgres. I found below https://www.postgresql.org/docs/current/static/pgcrypto.html documentation related to hashing but not sure which one to use.

Looks like md5 hashing with 32 bit is one option - Hashing a String to a Numeric Value in PostgresSQL - but not 100% sure

Improve this question
1
  • Either md5 or the pgcrypto hash functions should work fine. Commented Feb 21, 2018 at 20:15
Related questions
4
Migrate SPATIAL data from Oracle to Postgresql
3
Import oracle dump to PostgreSQL
1
how to migrate oracle data into postgres?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.