John DeSoi <desoi@pgedit.com> writes:
> On Feb 28, 2006, at 12:53 AM, Josh Close wrote:
>> Where can I get the data type from the row description?
> The oid maps to the pg_type table:
> select oid, typname from pg_type order by oid;
Also, the format_type function might be useful:
regression=# select format_type(1042, 44); format_type
---------------character(40)
(1 row)
regards, tom lane