Skip to content

Instantly share code, notes, and snippets.

@remvee

remvee/md5.sql

Created September 21, 2020 09:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save remvee/333718877de561caf4e0d979895dfbb0 to your computer and use it in GitHub Desktop.
Save remvee/333718877de561caf4e0d979895dfbb0 to your computer and use it in GitHub Desktop.
Download ZIP
MD5 sum a query result in PostgreSQL
Raw
md5.sql
SELECT md5(array_agg((t.*)::varchar)::varchar)
FROM (
SELECT users.*, departments.name FROM users INNER JOIN departments.id ON users.department_id
) as t;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment