Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: Tom LaneDate: 2006-02-28 06:42:26
Subject: Re: row description, protocol 3
Previous:From: Josh CloseDate: 2006-02-28 05:53:58
Subject: row description, protocol 3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group