How to hide value in database PostgreSQL

Question

Anybody can help me regarding the database postgres? I need to hide the value in table that was created.I need to hide the data password as like below example:

username password ana 123

I want the password appear like * Can anyone help me? Thank you in advance.

Answer 1

Take a look at pgcrypto module for some more options (like Extended DES crypt and PGP encryption). I don't recommend using MD5, because (IMHO) it's easily breakable nowadays (especially without any salt). Better choice is SHA-512 (or some of SHA-3 candidates: BLAKE, Grøstl etc.).

I think that it's good idea to check your hiding method against some (possibly GPU-accelerated) tools like hashcat. It really depends how valuable data you want to store.

Answer 2

The usual, and best, way is to store the MD5 of the password and compare that with the MD5 of the password entered. It fairly safe (but brute force can crack it given enough time).