From: Tom Lane <tgl@sss.pgh.pa.us>
To: John DeSoi <desoi@pgedit.com>
Cc: Josh Close <narshe@gmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: row description, protocol 3
Date: Tue, 28 Feb 2006 01:42:26 -0500
Message-ID: <11010.1141108946@sss.pgh.pa.us> (raw)
In-Reply-To: <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com>
References: <4a0cafe20602272153s7a3e0c2fme8516170675df1e0@mail.gmail.com>
<3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com>
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
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: tgl@sss.pgh.pa.us, desoi@pgedit.com, narshe@gmail.com
Subject: Re: row description, protocol 3
In-Reply-To: <11010.1141108946@sss.pgh.pa.us>
* 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