Skip site navigation (1) Skip section navigation (2)

Re: type list

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: type list
Date: 2011-12-12 23:20:15
Message-ID: CAHyXU0z0+4LuRLFVe=7ccagFcCnQ4VjBqcz8K-ir-7c4=3Q_6w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

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        |
(1 row)


merlin

In response to

  • type list at 2011-12-12 21:29:06 from Jean-Yves F. Barbier

Responses

pgsql-novice by date

Next:From: Jorge PerezDate: 2011-12-13 02:20:15
Subject: tune postgresql on windows
Previous:From: Mauro ZilianiDate: 2011-12-12 22:09:13
Subject: PQexecPrepared and boolean type coding,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group