X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 41B609FB35B for ; Sat, 5 Aug 2006 17:44:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 23933-03-5 for ; Sat, 5 Aug 2006 20:43:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 783E99FB366 for ; Sat, 5 Aug 2006 17:43:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.185]) by svr4.postgresql.org (Postfix) with ESMTP id 7A8965AF02A for ; Sat, 5 Aug 2006 20:43:41 +0000 (GMT) Received: from mac.com (smtpin04-en2 [10.13.10.149]) by smtpout.mac.com (Xserve/8.12.11/smtpout15/MantshX 4.0) with ESMTP id k75KhcCP008180 for ; Sat, 5 Aug 2006 13:43:38 -0700 (PDT) Received: from [192.168.24.30] (pd954fb66.dip0.t-ipconnect.de [217.84.251.102]) (authenticated bits=0) by mac.com (Xserve/smtpin04/MantshX 4.0) with ESMTP id k75KhaSI014342 for ; Sat, 5 Aug 2006 13:43:38 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-interfaces@postgresql.org From: osxdeveloper@mac.com Subject: getting the correct column size.... Date: Sat, 5 Aug 2006 22:43:35 +0200 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.961 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200608/13 X-Sequence-Number: 6227 Hi all! I am developing an application (on Mac OS X, using ObjC and Cocoa) the uses the libpq client library. Now I have difficulties to get the correct size of several sql types. for example: A table as a char(10) column. When I get the size via PQfmod() I get 14 as size value. 2. example: My table has a decimal(19,4) field (19=precision, 4=scale). How can I get the 19,4 value via the client lib? I did not find any other way to get column sizes. How can I get the values? Thanks for any help! Regards, Ralf