On Sun, Dec 18, 2011 at 10:43 AM, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> 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.
yeah...another way to do that is via psql -E, which echos internally
thrown queries to the console.
merlin
