Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s0mZc-007Fif-Os
	for pgsql-general@arkaria.postgresql.org; Sat, 27 Apr 2024 18:14:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s0mZa-009Vid-6Z
	for pgsql-general@arkaria.postgresql.org; Sat, 27 Apr 2024 18:14:55 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1s0mZZ-009ViV-Rm
	for pgsql-general@lists.postgresql.org; Sat, 27 Apr 2024 18:14:54 +0000
Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1s0mZX-000NjI-Oy
	for pgsql-general@lists.postgresql.org; Sat, 27 Apr 2024 18:14:54 +0000
Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-5ac90ad396dso1840270eaf.3
        for <pgsql-general@lists.postgresql.org>; Sat, 27 Apr 2024 11:14:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1714241690; x=1714846490; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=fW/kQ4pyeZBfHviut/NmLLVf0nuikKnacqulvnHGVbk=;
        b=Hfc8vV/t54/A8//v1jf42w8oqCpZhHV2wqRYEqUg3FM/jpOrwNC/r7Fc/2Zq4ILvCF
         9i9oAVwTGT+XoqNUs2ec9siEdNdugQREtRO92ewHit8IWy43XFlNvXx9eK587fhLa4Pl
         a0v36U/F2ky+w5FElKvY0HzT+mPiSxbxS/K9nHB4yfk4WdVqaS43qTNNouqriwr6OFK1
         mizMyvDlh5myexpXsr+yFz04xbUiFV177CU/0CFMo+uX7c4JT/XHQSVBNJU8aDnfCXWz
         IZoAbDyEm0LJKDtpDFl+TBNo6KNxQHR0FAfIGvLDiksO9EZ9i6ifS6scqOWqPYwNWcbO
         Sx0A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1714241690; x=1714846490;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=fW/kQ4pyeZBfHviut/NmLLVf0nuikKnacqulvnHGVbk=;
        b=DEdkmLa0mvrl8ZO564sRdpkv1FlcmFsQVB2kLLQ7d0yPbm1cnWoMXRBA8EpERY1QPG
         vxR3gmmYuT62xe5RiJSq06Qj5Wo8bUGjiAUzC778HZ+RO3Wn20uj0+qlP334Cg0NLKah
         xPa41tkeG7UngzIbup7tD8Pi8ASptmHoTABf5ijrNy0k2dxdZm3XZraS9DaQdIWKEgCy
         aDlsqUHwb35SS+diyXlkr0j26VFssrtv6OGZOSOlo2nxUhQjTR+YsUyMn69vKw+JbaET
         5a14yvxUCYSsJBtFiA19vsuHckisBRZmHA1+3T6oqgXMiZj5U9xsdAjni6oBBwvxxlgX
         4kAg==
X-Gm-Message-State: AOJu0Yxyngjf/lpP4Mu9I0bPV9LtlrpItLP0spXVxuEzlgJuoF6m8md1
	yFJD+cyDtHs2wwxov2tSmu5ZAua9Nc5ZyMM5cdhGANE63bqc0gVvwbfcI42zorAVi2iTSg6PO1T
	6eAh5OLtnoZX6G0w1TLoE2rEQG5g=
X-Google-Smtp-Source: AGHT+IGRD4AEpyNvNFhvWjNivReupwEqMAtuDpObTQfrpBmm7F7a7ANxqa4s+EbdtOnHiO6fr0y/f9I+6L+JwnFAIVo=
X-Received: by 2002:a4a:44c2:0:b0:5ac:9f5f:9c99 with SMTP id
 o185-20020a4a44c2000000b005ac9f5f9c99mr7836182ooa.8.1714241689665; Sat, 27
 Apr 2024 11:14:49 -0700 (PDT)
MIME-Version: 1.0
References: <CAM-5MT2MNN3drQLUZOHdOzwQMih=eJ=zzHbgwFsAbNeMZaM4=A@mail.gmail.com>
In-Reply-To: <CAM-5MT2MNN3drQLUZOHdOzwQMih=eJ=zzHbgwFsAbNeMZaM4=A@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 27 Apr 2024 11:14:12 -0700
Message-ID: <CAKFQuwacQyx_ZhG68DyE8zQV=D8vGc+r07e+9dYf87MVUHvM2w@mail.gmail.com>
Subject: Re: Stess test via libpq for postgreSQL DB
To: Sasmit Utkarsh <utkarshsasmit@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f8ca7e061717fe54"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwacQyx_ZhG68DyE8zQV%3DD8vGc%2Br07e%2B9dYf87MVUHvM2w%40mail.gmail.com>
Precedence: bulk

--000000000000f8ca7e061717fe54
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Apr 27, 2024 at 11:07=E2=80=AFAM Sasmit Utkarsh <utkarshsasmit@gmai=
l.com>
wrote:

>
> But i have some clarifications if we can use it to execute PLSQL code
> blocks rather than standalone SQL queries.
>

https://www.postgresql.org/docs/current/sql-do.html

David J.

--000000000000f8ca7e061717fe54
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, Apr 27, 2024 at 11:07=E2=80=AFAM Sasmit Utkarsh &l=
t;<a href=3D"mailto:utkarshsasmit@gmail.com">utkarshsasmit@gmail.com</a>&gt=
; wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><br></div></blockquote><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>But i=
 have some clarifications=C2=A0if we can use it to execute PLSQL=C2=A0code =
blocks rather than standalone SQL queries<span class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif">.</span></div></div></blockquo=
te><div><br></div><div class=3D"gmail_default" style=3D"font-family:arial,h=
elvetica,sans-serif"><a href=3D"https://www.postgresql.org/docs/current/sql=
-do.html">https://www.postgresql.org/docs/current/sql-do.html</a></div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><=
br></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,=
sans-serif">David J.</div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000f8ca7e061717fe54--