On Feb 28, 2006, at 12:53 AM, Josh Close wrote:
> I'm getting row description and row data back from Postgres, but I
> can't figure out how to get the datatype of the row field.
> There is a type modifier and an oid of a the field's data type, but
> I haven't found anywhere those match up with Postgres data types.
> 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;
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2006-02-28 06:42:26|
|Subject: Re: row description, protocol 3 |
|Previous:||From: Josh Close||Date: 2006-02-28 05:53:58|
|Subject: row description, protocol 3|