Is there a way to show a user-defined postgresql enumerated type definition?

Question

Let's say we've defined a postgresql type:

CREATE TYPE my_type AS ENUM('foo', 'bar'); 

Is there any way to show the type definition after creation ?

I would expect "\d my_type" to show me "ENUM('foo', 'bar')", but it says :

Did not find any relation named "my_type" 

The pg_type table doesn't seem to give enough information.

Answer 1

Check this:

select enum_range(null::my_type) 

I think this is a much simpler solution :).

Answer 2

It's \dT you're after, but it doesn't give it as a "CREATE" statement. You use \dD for domains.

\dT+ action.action_status                           List of data types  Schema |         Name         | Internal name | Size | Elements | Description  --------+----------------------+---------------+------+----------+-------------  action | action.action_status | action_status | 4    | pending +|          |                      |               |      | live    +|          |                      |               |      | done    +|          |                      |               |      | notdone  |  (1 row)