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

Re: Data Types and Their Aliases

From: "Garcia, Joshua" <Joshua(dot)Garcia(at)xerox(dot)com>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Data Types and Their Aliases
Date: 2006-07-11 01:13:39
Message-ID: E00A3B716AD4C84FB97E42367015E8A00BFF16@usa5911mf01.na.xerox.net (view raw or flat)
Thread:
Lists: pgsql-novice
Ah...ya I know about pg_type and the manual...those are really the best
references for the aliases huh?

Thanks again,
Josh

-----Original Message-----
From: John DeSoi [mailto:desoi(at)pgedit(dot)com] 
Sent: Monday, July 10, 2006 4:56 PM
To: Garcia, Joshua
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Data Types and Their Aliases


On Jul 10, 2006, at 6:24 PM, Garcia, Joshua wrote:

> Where is there a good reference that shows all the data types and  
> their aliases?
>
>
>
> For example, the reference would show that float8 is double  
> precision and _float8 is an array of double precision data types.

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE- 
TABLE

Arrays are not included here, but if you need more details you can  
look at the pg_type system table.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2006-07-11 01:40:26
Subject: Re: Data Types and Their Aliases
Previous:From: John DeSoiDate: 2006-07-10 23:56:23
Subject: Re: Data Types and Their Aliases

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