Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Log Info - Mailing list pgsql-general

From Jethish Jethish
Subject Re: PostgreSQL Log Info
Date
Msg-id CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Log Info  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: PostgreSQL Log Info
Re: PostgreSQL Log Info
Re: PostgreSQL Log Info
Re: PostgreSQL Log Info
Re: PostgreSQL Log Info
List pgsql-general
Tree view

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. 

pgsql-general by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: Fwd: A million users
Next
From: Matthias Apitz
Date:
Subject: Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10