Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UefWr-0004QX-87 for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2013 05:54:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UefWq-0007tN-71 for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2013 05:54:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UefWn-0007s9-SY for pgsql-general@postgresql.org; Tue, 21 May 2013 05:54:29 +0000 Received: from hogranch.com ([75.101.82.47]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UefWe-0005GF-1B for pgsql-general@postgresql.org; Tue, 21 May 2013 05:54:29 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id r4L5sCl20132 for ; Mon, 20 May 2013 22:54:13 -0700 Message-ID: <519B0C04.8070102@hogranch.com> Date: Mon, 20 May 2013 22:54:12 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: ODBC constructs References:

In-Reply-To: Content-Type: multipart/alternative; boundary="------------010609080609070600060705" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------010609080609070600060705 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 5/20/2013 10:11 PM, Dev Kumkar wrote: > On Mon, May 20, 2013 at 9:12 PM, Atri Sharma > wrote: > > > If you wish to work in C,then,I would suggest libpq.I would wait > for more replies on this,as I have little knowledge > about psqlODBC. > > > Thanks for the comments. Yes objective is to work in C and found libpq > useful but am not sure about psqlODBC. > It would be really great to get comments from community here regarding > comparison between both of them and also performance perspective. > Based on my reading so far libpq is good from performance perspective. libpq lets you talk directly to postgres in its native tongue. ODBC implements a sort of abstraction. IMHO, its like trying to type with mittens on. -- john r pierce 37N 122W somewhere on the middle of the left coast --------------010609080609070600060705 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

On 5/20/2013 10:11 PM, Dev Kumkar wrote:

On Mon, May 20, 2013 at 9:12 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge

about psqlODBC.

Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about psqlODBC.

It would be really great to get comments from community here regarding comparison between both of them and also performance perspective. Based on my reading so far libpq is good from performance perspective.

libpq lets you talk directly to postgres in its native tongue.

ODBC implements a sort of abstraction. IMHO, its like trying to type with mittens on.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

--------------010609080609070600060705--