Re: row description, protocol 3 - Mailing list pgsql-interfaces

From John DeSoi
Subject Re: row description, protocol 3
Date
Msg-id 3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com
Whole thread Raw
In response to row description, protocol 3  ("Josh Close" <narshe@gmail.com>)
Responses Re: row description, protocol 3
Re: row description, protocol 3
List pgsql-interfaces
Johsh,

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.
http://pgedit.com/
Power Tools for PostgreSQL



pgsql-interfaces by date:

Previous
From: "Josh Close"
Date:
Subject: row description, protocol 3
Next
From: Tom Lane
Date:
Subject: Re: row description, protocol 3