MIME-Version: 1.0
References: <CAKeSjMiBZuMX+R3mTmxj-5DUqKN9disMALRnTPv-5B3+CUn6Hg@mail.gmail.com>
 <CAKFQuwYNhgArOxhAXwbf3cY=jmJnKYo8c1R66NLFtAvpmKktCA@mail.gmail.com>
In-Reply-To: <CAKFQuwYNhgArOxhAXwbf3cY=jmJnKYo8c1R66NLFtAvpmKktCA@mail.gmail.com>
From: Jethish Jethish <jethish777@gmail.com>
Date: Fri, 22 Nov 2024 13:02:27 +0530
Message-ID: <CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com>
Subject: Re: PostgreSQL Log Info
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002a6acc06277b634f"
Archived-At: <https://www.postgresql.org/message-id/CAKeSjMgH1td7Vuz%3Dh_Knf_bP7uBxjFRCHtuMi1Z2%2Bphd3F7kRg%40mail.gmail.com>
Precedence: bulk

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

Hi David,

If an select query is fired I need the query returned values needs to be
logged in my PostgreSQL log file.


For example if a select query returns 5 rows I need the same in the log
file

On Fri, Nov 22, 2024, 10:49=E2=80=AFAM David G. Johnston <david.g.johnston@=
gmail.com>
wrote:

> On Thursday, November 21, 2024, Jethish Jethish <jethish777@gmail.com>
> wrote:
>>
>> Is it possible to log the rows returned by a query in the PostgreSQL log=
s?
>>
>
> As a practical matter, no.  That said, given one can get row contents int=
o
> the server log in various ways, what is the use case for why this
> capability is thought to be needed?
>
> David J.
>

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

<div dir=3D"auto"><p dir=3D"ltr">Hi David,</p>
<p dir=3D"ltr">If an select query is fired I need the query returned values=
 needs to be logged in my PostgreSQL log file.<br>
</p><p dir=3D"ltr"><br></p><p dir=3D"ltr">For example if a select query ret=
urns 5 rows I need the same in the log file=C2=A0</p></div>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri=
, Nov 22, 2024, 10:49=E2=80=AFAM David G. Johnston &lt;<a href=3D"mailto:da=
vid.g.johnston@gmail.com" rel=3D"noreferrer noreferrer" target=3D"_blank">d=
avid.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex">On Thursday, November 21, 2024, Jethish Jethish &lt;<a href=3D"mailto=
:jethish777@gmail.com" rel=3D"noreferrer noreferrer noreferrer" target=3D"_=
blank">jethish777@gmail.com</a>&gt; wrote:<blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><d=
iv dir=3D"auto"><div dir=3D"auto">Is it possible to log the rows returned b=
y a query in the PostgreSQL logs?</div></div></blockquote><div><br></div><d=
iv>As a practical matter, no.=C2=A0 That said, given one can get row conten=
ts into the server log in various ways, what is the use case for why this c=
apability is thought to be needed?</div><div><br></div><div>David J.=C2=A0<=
br></div>
</blockquote></div>

--0000000000002a6acc06277b634f--