Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ueg7S-0007GC-72 for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2013 06:32:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ueg7R-00039m-EH for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2013 06:32:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ueg7Q-00039b-5E; Tue, 21 May 2013 06:32:20 +0000 Received: from smtp-outbound-2.vmware.com ([208.91.2.13]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ueg7K-000631-WC; Tue, 21 May 2013 06:32:18 +0000 Received: from sc9-mailhost1.vmware.com (sc9-mailhost1.vmware.com [10.113.161.71]) by smtp-outbound-2.vmware.com (Postfix) with ESMTP id D2CF528561; Mon, 20 May 2013 23:32:11 -0700 (PDT) Received: from zcs-prod-ext-mta-1.vmware.com (zcs-prod-ext-mta-1.vmware.com [10.113.62.223]) by sc9-mailhost1.vmware.com (Postfix) with ESMTP id CD748186CB; Mon, 20 May 2013 23:32:11 -0700 (PDT) Received: from zcs-prod-ext-mta-1.vmware.com (localhost.localdomain [127.0.0.1]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTP id 64A2412002F; Mon, 20 May 2013 23:37:32 -0700 (PDT) Received: from [192.168.1.90] (zimbra-prod-ext-proxy-vip.vmware.com [10.113.63.87]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTPSA; Mon, 20 May 2013 23:37:30 -0700 (PDT) Message-ID: <519B14E7.3010806@vmware.com> Date: Tue, 21 May 2013 09:32:07 +0300 From: Heikki Linnakangas Organization: VMware User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.12) Gecko/20130116 Icedove/10.0.12 MIME-Version: 1.0 To: Dev Kumkar CC: Atri Sharma , "pgsql-odbc@postgresql.org" , "pgsql-general@postgresql.org" Subject: Re: [ODBC] ODBC constructs References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -8.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 On 21.05.2013 08:11, 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 is generally-speaking better than psqlodbc. The advantage of ODBC is that if you have a suitable driver, you can connect to other DBMS' as well, while libpq will only work with PostgreSQL. Unless you need such portability, go with libpq. - Heikki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general