Re: Data types?

If you need to know the OID of a type (e.g., for use in libpq) I find

	select oid, typname from pg_type

useful.  By the way, what are all those types prefixed with an 
underscore?  Are these ever delivered to a client?

Tim

Tom Lane wrote:

> Christopher Sawtell <csawtell@xtra.co.nz> writes:
> 
>> On Thu, 08 Mar 2001 12:29, Flemming Frøkjær wrote:
>> 
>>> How do i find out what data types are available in PostgreSQL.
>> 
> 
>> Look in the regression tests. Interesting stuff.
> 
> 
> And there's always "select * from pg_type" ... not to mention the source
> code ...
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html


-- 
Timothy H. Keitt
Department of Ecology and Evolution
State University of New York at Stony Brook
Phone: 631-632-1101, FAX: 631-632-7626
http://life.bio.sunysb.edu/ee/keitt/