Is it possible to convert enums to text in PostgreSQL

Question

Is is possible to convert an enum declared in a postgresql schema to text so that I could use like clause for the enum column?

Answer 1

You can cast the enum into text easily and use any textual operators on it.

SELECT * FROM table WHERE enumfield::TEXT LIKE 'Some%';

There might be a better way to handle what you want to achieve since the performance of this isn't the best.