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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

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 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-2017 The PostgreSQL Global Development Group