Re: PostgreSQL Log Info

On 11/21/24 23:32, Jethish Jethish 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

What if the query returns 500,000 rows?

What is the purpose of retaining this information?

>
>
> On Fri, Nov 22, 2024, 10:49 AM David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Thursday, November 21, 2024, Jethish Jethish
> <jethish777(at)gmail(dot)com <mailto:jethish777(at)gmail(dot)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.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com