Skip to content

Instantly share code, notes, and snippets.

View ghobadkhan's full-sized avatar
💛
I'm Fine

ghobadkhan

💛
I'm Fine
View GitHub Profile
@ghobadkhan
ghobadkhan / psql_list_enums_readable.sql
Last active September 9, 2021 12:04
Lists all stored enums in a human readable format - Postgresql
SELECT
type.typname AS name,
string_agg(enum.enumlabel, '|') AS value
FROM pg_enum AS enum
JOIN pg_type AS type
ON (type.oid = enum.enumtypid)
GROUP BY type.typname;