X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 81A849DC832 for ; Tue, 28 Feb 2006 02:42:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38517-07 for ; Tue, 28 Feb 2006 02:42:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 469BD9DCA2D for ; Tue, 28 Feb 2006 02:42:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k1S6gQAI011011; Tue, 28 Feb 2006 01:42:26 -0500 (EST) To: John DeSoi cc: "Josh Close" , pgsql-interfaces@postgresql.org Subject: Re: row description, protocol 3 In-reply-to: <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com> References: <4a0cafe20602272153s7a3e0c2fme8516170675df1e0@mail.gmail.com> <3981A0F6-5530-41F8-A232-F95B962DB5C4@pgedit.com> Comments: In-reply-to John DeSoi message dated "Tue, 28 Feb 2006 01:10:47 -0500" Date: Tue, 28 Feb 2006 01:42:26 -0500 Message-ID: <11010.1141108946@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.111 required=5 tests=[AWL=0.111] X-Spam-Score: 0.111 X-Spam-Level: X-Archive-Number: 200602/84 X-Sequence-Number: 6048 John DeSoi 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