Re: type list

On Mon, 12 Dec 2011 17:20:15 -0600
Merlin Moncure <mmoncure@gmail.com> wrote:

Sorry for the late answer.

> On Mon, Dec 12, 2011 at 3:29 PM, Jean-Yves F. Barbier <12ukwn@gmail.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