Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kcrD0-0000mI-66 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Nov 2020 14:34:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kcrCz-0004ny-0I for pgsql-admin@arkaria.postgresql.org; Wed, 11 Nov 2020 14:34:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kcrCy-0004nq-P9 for pgsql-admin@lists.postgresql.org; Wed, 11 Nov 2020 14:34:48 +0000 Received: from mail-qt1-x833.google.com ([2607:f8b0:4864:20::833]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kcrCw-0003ce-NM for pgsql-admin@postgresql.org; Wed, 11 Nov 2020 14:34:47 +0000 Received: by mail-qt1-x833.google.com with SMTP id n63so1388945qte.4 for ; Wed, 11 Nov 2020 06:34:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=yZdli9V/wRyug+yq+Dq2svy0tz+a14UhkIxXra4gDw4=; b=GSkKRXahdI4ntWAJl93z/JKchsueKV6fwuXG4EIiS5k1B/mWqxmItHmbgp4Kkyzbno pA+Di0gfGjIc4RyFuhL47H1UEkW7LJjUPtWrBhRZVW9TgcBQDES7SiMYwTTCuF/122dn +CZU805brC2awKXnocz6RjSFPGnHhYVu8pk4HCU6iuuTpzzu+2YZWCYfjiJ0Uh4YKLIU 9A/pCIqaKPM8cVzJ86c7eAoHWEr/lvDWAi83ZXACUGBpwk8OGPIUnCA6YMwPX24VHeP1 U87Xy2vOfvtW92s1drSoJqt90hDxb17jKtYhdz6KeLoBt5jNKe48rT7i9ZHW+NBCzi2h dnCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=yZdli9V/wRyug+yq+Dq2svy0tz+a14UhkIxXra4gDw4=; b=JpV3iLlzXmD9QXvGGV+woIQAMlI2FKN0LkDiv5rZsjwkIH/cXwbBrKpwuw4bHSQpbk EXqHhrHqQQPSLV3WIEszDOoTOaTsBhoieYf4dkvvvALC+mBrDAohP5H/3HDQrq8qZBv3 fJ0CVbgHxcWQKbCDi0IpgvzV13L6QA7jy2m4VSH4Yuk1gWKAxwqfDiyaIRzzQPLmU8bl 8AztB7J5c+pRm5tWWzomR6ZgHd8rzMuHjrUz/lqaFFYEHhaziD4Ufd/F1N547ab2jgpb Vr0t/UunWNSpj1C54ZKE/nKlu1VqEQY3bNs0UgDlKBz22QfC55A2KGwGCVFFu2DKGI8l afKA== X-Gm-Message-State: AOAM5319MPpXXpj9PgA8TLL3rXNgUQHfHEcpChruP6TfNy85SzfiOHqb nDgnsoWBSvkffOwJtgrRlkA= X-Google-Smtp-Source: ABdhPJxepwo2tASUiI5qQtAsQZ8CTCp0+iEMfYfnNg5YnvB4hkbcsjiPTUU21uM6IepajH3h31r1lA== X-Received: by 2002:ac8:5319:: with SMTP id t25mr22538130qtn.351.1605105285865; Wed, 11 Nov 2020 06:34:45 -0800 (PST) Received: from [192.168.254.66] (h217.104.141.67.dynamic.ip.windstream.net. [67.141.104.217]) by smtp.gmail.com with ESMTPSA id q3sm2121032qkf.24.2020.11.11.06.34.45 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 11 Nov 2020 06:34:45 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: PSQL CLI Drivers Date: Wed, 11 Nov 2020 09:34:44 -0500 Message-Id: <5F327F21-567E-4149-BE25-01DB97D42C0D@gmail.com> References: Cc: Thomas Kellerer , pgsql-admin@postgresql.org In-Reply-To: To: Koteswara Rao Daliparthi X-Mailer: iPad Mail (18A8395) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I think that would depend on both what you want to accomplish and the skill s= ets of your developers. C would certainly be faster, but Java capability may= be acceptable to what you=E2=80=99re trying to do. Sent from my iPad > On Nov 11, 2020, at 9:31 AM, Koteswara Rao Daliparthi w= rote: >=20 > =EF=BB=BFThanks guys, for performance, should we choose libpq or JDBC? I k= now C will be faster than Java, but just wanted to confirm. >=20 > Sent from my iPhone >=20 >> On Nov 11, 2020, at 9:10 AM, Thomas Kellerer wrote: >>=20 >> =EF=BB=BF >>=20 >> Koteswara Rao Daliparthi schrieb am 11.11.2020 um 15:02: >>> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC?? >>=20 >>=20 >> It uses libpq >>=20 >> https://www.postgresql.org/docs/current/libpq.html >>=20 >>=20 >>=20 >=20 >=20