Re: Data Types and Their Aliases

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