Skip to content

Instantly share code, notes, and snippets.

@emailrhoads

emailrhoads/list_pg_enums.sql

Created April 22, 2020 21:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save emailrhoads/efd57ab2df98963ebc7becd01e08f78b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save emailrhoads/efd57ab2df98963ebc7becd01e08f78b to your computer and use it in GitHub Desktop.
Download ZIP
[List PG Enums] #postgres
Raw
list_pg_enums.sql
select n.nspname as enum_schema,
t.typname as enum_name,
e.enumlabel as enum_value
from pg_type t
join pg_enum e on t.oid = e.enumtypid
join pg_catalog.pg_namespace n ON n.oid = t.typnamespace
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment