From: John DeSoi <desoi@pgedit.com>
To: Josh Close <narshe@gmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: row description, protocol 3
Date: Tue, 28 Feb 2006 01:10:47 -0500
Message-ID: <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com> (raw)
In-Reply-To: <4a0cafe20602272153s7a3e0c2fme8516170675df1e0@mail.gmail.com>
References: <4a0cafe20602272153s7a3e0c2fme8516170675df1e0@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: desoi@pgedit.com, narshe@gmail.com
Subject: Re: row description, protocol 3
In-Reply-To: <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox