Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 553BA634733 for ; Wed, 3 Jun 2009 16:01:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32735-10 for ; Wed, 3 Jun 2009 16:01:28 -0300 (ADT) X-Greylist: delayed 00:16:08.582276 by SQLgrey-1.7.6 Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by mail.postgresql.org (Postfix) with ESMTP id 633A1632300 for ; Wed, 3 Jun 2009 16:01:28 -0300 (ADT) Received: from deneb.vpn.enyo.de ([212.9.189.177] helo=deneb.enyo.de) by mail.enyo.de with esmtp id 1MBvSe-0000hF-QZ for pgsql-interfaces@postgresql.org; Wed, 03 Jun 2009 20:45:16 +0200 Received: from fw by deneb.enyo.de with local (Exim 4.69) (envelope-from ) id 1MBvSe-0006Uq-GV for pgsql-interfaces@postgresql.org; Wed, 03 Jun 2009 20:45:16 +0200 From: Florian Weimer To: pgsql-interfaces@postgresql.org Subject: Type OIDs Date: Wed, 03 Jun 2009 20:45:16 +0200 Message-ID: <877hztupfn.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/1 X-Sequence-Number: 6869 I'd like to use type information in a query result to convert its elements to more appropriate types if necessary. Can I embed the types I'm interested in into my program, or should I query the server at least once per connection to get the mapping? I'm interested in types such as INTEGER, TEXT, BYTEA, etc. No user defined types, and nothing fancy. Ultra-long-term portability isn't required, either.