Re: type list
От
Jean-Yves F. Barbier
Тема
Re: type list
Дата
Msg-id
20111218174334.2bac93bc@anubis.defcon1
Ответ на
Re: type list (Merlin Moncure)
Список
Дерево обсуждения
type list "Jean-Yves F. Barbier" <12ukwn@gmail.com>
Re: type list Merlin Moncure <mmoncure@gmail.com>
Re: type list "Jean-Yves F. Barbier" <12ukwn@gmail.com>
Re: type list Merlin Moncure <mmoncure@gmail.com>
getting auto increment id value M. Emre Çolak <memrecolak@hotmail.com>
Re: getting auto increment id value Josh Kupershmidt <schmiddy@gmail.com>
On Mon, 12 Dec 2011 17:20:15 -0600
Merlin Moncure 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
В списке pgsql-novice по дате отправления
