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@pgedit.com]
Sent: Monday, July 10, 2006 4:56 PM
To: Garcia, Joshua
Cc: pgsql-novice@postgresql.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