PostgreSQL MD5() Function
The PostgreSQL MD5() function returns an MD5 128-bit checksum representation of a given string. This function returns a 32 character hexadecimal string as the result.
The MD5() function returns NULL if the string is NULL.
Syntax
MD5(string)
Parameters
string |
Required. Specify the plaintext string used to generate the MD5 128-bit checksum. |
Return Value
Returns the MD5 128-bit checksum representation of a string.
Example:
The example below shows the usage of MD5() function.
SELECT MD5('xyz');
Result: 'd16fb36f0911f878998c136191af705e'
SELECT MD5('password');
Result: '5f4dcc3b5aa765d61d8327deb882cf99'
SELECT MD5('alphacodingskills');
Result: 'de0e02d2e002982195993556f112635c'
SELECT MD5(123);
Result: '202cb962ac59075b964b07152d234b70'
SELECT MD5(NULL);
Result: NULL
❮ PostgreSQL Functions
