Thread

1. Data types?

   Flemming Froekjaer <flemming@froekjaer.org> — 2001-03-07T23:29:19Z

   How do i find out what data types are available in PostgreSQL.
   I know there are more that the ones in the docs, and i ones saw a command
   to list all the data types. And there was a lot more than the ones from the
   docs.
   
   \Flemming
   
   
   

2. Re: Data types?

   Christopher Sawtell <csawtell@xtra.co.nz> — 2001-03-08T00:34:18Z

   On Thu, 08 Mar 2001 12:29, Flemming Frøkjær wrote:
   > How do i find out what data types are available in PostgreSQL.
   > I know there are more that the ones in the docs, and i ones saw a
   > command to list all the data types. And there was a lot more than the
   > ones from the docs.
   
   Look in the regression tests. Interesting stuff.
   
   -- 
   Sincerely etc.,
   
    NAME       Christopher Sawtell
    CELL PHONE 021 257 4451
    ICQ UIN    45863470
    EMAIL      csawtell @ xtra . co . nz
    CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
   
    -->> Please refrain from using HTML or WORD attachments in e-mails to me 
   <<--
   
   
   

3. Re: Data types?

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-08T00:59:50Z

   Christopher Sawtell <csawtell@xtra.co.nz> writes:
   > On Thu, 08 Mar 2001 12:29, Flemming Frkjr 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
   
   

4. Re: Data types?

   Timothy H. Keitt <timothy.keitt@stonybrook.edu> — 2001-03-08T18:00:05Z

   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/
   
   
   

5. Re: Re: Data types?

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-12T21:06:38Z

   "Timothy H. Keitt" <Timothy.Keitt@StonyBrook.Edu> writes:
   > By the way, what are all those types prefixed with an 
   > underscore?  Are these ever delivered to a client?
   
   If foo is a simple type, then (by convention) _foo is an array of foo,
   ie, it's the internal name for "foo[]".
   
   "CREATE TYPE foo" makes the array type _foo as well...
   
   			regards, tom lane