Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Log Info - Mailing list pgsql-general

From Ron Johnson
Subject Re: PostgreSQL Log Info
Date
Msg-id CANzqJaBHN3wt2pdwqLEhaaJ4CgQVg7+_5Vwjk2DNP89OQSh+AQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Log Info  (Jethish Jethish <jethish777@gmail.com>)
List pgsql-general
Tree view
Isn't "I need the query returned values" the purpose of the client application?

On Fri, Nov 22, 2024 at 2:32 AM Jethish Jethish <jethish777@gmail.com> wrote:

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 AM 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 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. 


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Achilleas Mantzios - cloud
Date:
Subject: Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10
Next
From: Matthias Apitz
Date:
Subject: Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10