How do i query values of an enum in postgresql

Question

Hi i want to use an enum in postgresql as an alternative to making a table, because the values my never change, but i want to be able to retrieve these values for an application that might check just in case they do, is there any way the query it to get the values?

Duplicate of stackoverflow.com/questions/1616123/…

Bill Karwin
– Bill Karwin

2009-11-04 22:48:38 +00:00
Commented Nov 4, 2009 at 22:48 — Bill Karwin
– Bill Karwin, Commented Nov 4, 2009 at 22:48

Justin Ohms · Accepted Answer · 2013-08-29 03:17:48Z

10

SELECT unnest(enum_range(NULL::your_enum))::text AS your_column

This will return a single column result set of the contents of the enum "your_enum" with a column named "your_column" of type text.

answered Aug 29, 2013 at 3:17

Justin Ohms

3,5931 gold badge35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Richard Huxton · Accepted Answer · 2009-11-06 15:25:08Z

0

See the manual: Functions and Operators / Enum Support Functions You probably want the enum_range(...) function. Alternatively, you could look in the system catalogues: pg_enum

answered Nov 6, 2009 at 15:25

Richard Huxton

541 bronze badge

Collectives™ on Stack Overflow

How do i query values of an enum in postgresql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related