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

From Tom Lane
Subject Re: row description, protocol 3
Date
Msg-id 11010.1141108946@sss.pgh.pa.us
Whole thread Raw
In response to Re: row description, protocol 3  (John DeSoi <desoi@pgedit.com>)
List pgsql-interfaces
John DeSoi <desoi@pgedit.com> writes:
> On Feb 28, 2006, at 12:53 AM, Josh Close wrote:
>> 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;

Also, the format_type function might be useful:

regression=# select format_type(1042, 44); format_type  
---------------character(40)
(1 row)

        regards, tom lane


pgsql-interfaces by date:

Previous
From: John DeSoi
Date:
Subject: Re: row description, protocol 3
Next
From: Robert Gruszka
Date:
Subject: multiple threads using one connection