Re: type list

On Sun, Dec 18, 2011 at 10:43 AM, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> 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.

yeah...another way to do that is via psql -E, which echos internally
thrown queries to the console.

merlin