MIME-Version: 1.0
In-Reply-To: <CAKeSjMiBZuMX+R3mTmxj-5DUqKN9disMALRnTPv-5B3+CUn6Hg@mail.gmail.com>
References: <CAKeSjMiBZuMX+R3mTmxj-5DUqKN9disMALRnTPv-5B3+CUn6Hg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 21 Nov 2024 22:19:43 -0700
Message-ID: <CAKFQuwYNhgArOxhAXwbf3cY=jmJnKYo8c1R66NLFtAvpmKktCA@mail.gmail.com>
Subject: Re: PostgreSQL Log Info
To: Jethish Jethish <jethish777@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e1d3960627798717"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYNhgArOxhAXwbf3cY%3DjmJnKYo8c1R66NLFtAvpmKktCA%40mail.gmail.com>
Precedence: bulk

--000000000000e1d3960627798717
Content-Type: text/plain; charset="UTF-8"

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 logs?
>

As a practical matter, no.  That said, given one can get row contents into
the server log in various ways, what is the use case for why this
capability is thought to be needed?

David J.

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

On Thursday, November 21, 2024, Jethish Jethish &lt;<a href=3D"mailto:jethi=
sh777@gmail.com">jethish777@gmail.com</a>&gt; wrote:<blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><div dir=3D"auto"><div dir=3D"auto">Is it possible to log the rows =
returned by a query in the PostgreSQL logs?</div></div></blockquote><div><b=
r></div><div>As a practical matter, no.=C2=A0 That said, given one can get =
row contents into the server log in various ways, what is the use case for =
why this capability is thought to be needed?</div><div><br></div><div>David=
 J.=C2=A0<br></div>

--000000000000e1d3960627798717--