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/