Re: row description, protocol 3

From: John DeSoi <desoi(at)pgedit(dot)com>
To: "Josh Close" <narshe(at)gmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: row description, protocol 3
Date: 2006-02-28 06:10:47
Message-ID: 3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2006-02-28 06:42:26 Re: row description, protocol 3
Previous Message Josh Close 2006-02-28 05:53:58 row description, protocol 3