wirekang/md5_bytea.sql

Created November 13, 2023 01:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wirekang/bd7f24a34aefee402206a3959b846c8c.js"></script>
Save wirekang/bd7f24a34aefee402206a3959b846c8c to your computer and use it in GitHub Desktop.

Download ZIP

Postgres text to md5 bytea function

Raw

md5_bytea.sql

	create or replace function "md5_bytea"(text) returns bytea as
	$$
	select decode(md5($1), 'hex');
	$$
	language sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment