Re: type list

On Mon, 12 Dec 2011 17:20:15 -0600
Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

Sorry for the late answer.

> On Mon, Dec 12, 2011 at 3:29 PM, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> > Hi list,
> >
> > How can I list all values I gave to a type I created?
>
> what kind of type -- an enum?

Yep

> in psql, you can break down enums with \dT+
>
> postgres=# create type foo as enum ('a', 'b', 'c');
> CREATE TYPE
> Time: 13.000 ms
> postgres=# \dT+ foo
> List of data types
> Schema | Name | Internal name | Size | Elements | Description
> --------+------+---------------+------+----------+-------------
> public | foo | foo | 4 | a +|
> | | | | b +|
> | | | | c |

Thanks, I'm gonna log and analyse the corresponding query.

--
It's all right letting yourself go as long as you can let yourself
back. -- Mick Jagger