amitpatelx/gist:2567922

Created May 1, 2012 13:33

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/amitpatelx/2567922.js"></script>
Save amitpatelx/2567922 to your computer and use it in GitHub Desktop.

Download ZIP

PostgreSQL : Query to get all values of an enum

Raw

gistfile1.sql

	SELECT e.enumlabel
	FROM pg_enum e
	JOIN pg_type t ON e.enumtypid = t.oid
	WHERE t.typname = 'yourenumname'

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