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

Is it possible to query the database for the values of an enumerated type in 8.3.3?

From: "Nagle, Gail A \(US SSA\)" <gail(dot)nagle(at)baesystems(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Is it possible to query the database for the values of an enumerated type in 8.3.3?
Date: 2008-12-18 08:58:54
Message-ID: 7b4e7t$bae2g@dmzms99902.na.baesystems.com (view raw or flat)
Thread:
Lists: pgsql-novice
I have successfully created a user defined enumerated type using the
CREATE TYPE some_type_name AS ENUM command using Postgresql 8.3.3.

 

Is it possible to query the database (e.g. from psql or from the pgAdmin
III Query tool) for the enumerated values in the newly added user
defined type?

 

I did not find any direct documentation on this either in the manual or
on the web, but I may not know the correct search term(s) to use. Oracle
has a DESCRIBE command that does this type of thing for DB objects.
Perhaps the values need to be found indirectly by view some system
table?

 

Thank you!

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-12-18 13:32:58
Subject: Re: Is it possible to query the database for the values of an enumerated type in 8.3.3?
Previous:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2008-12-18 06:42:58
Subject: See description of a function

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