Skip to content

Instantly share code, notes, and snippets.

@ClimenteA

ClimenteA/view_enums_in_postgress.sql

Created March 27, 2025 09:36
Show Gist options
  • Save ClimenteA/db1f9b24329ecd331555d77a44febebb to your computer and use it in GitHub Desktop.
Save ClimenteA/db1f9b24329ecd331555d77a44febebb to your computer and use it in GitHub Desktop.
Download ZIP
How to view enum types in postgresql
Raw
view_enums_in_postgress.sql
SELECT * FROM pg_type
SELECT pg_type.typname AS enumtype,
pg_enum.enumlabel AS enumlabel
FROM pg_type
JOIN pg_enum
ON pg_enum.enumtypid = pg_type.oid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment