Re: PostgreSQL Log Info

From: Jethish Jethish <jethish777(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL Log Info
Date: 2024-11-22 07:32:27
Message-ID: CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Thursday, November 21, 2024, Jethish Jethish <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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2024-11-22 08:00:18 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10
Previous Message Kaare Rasmussen 2024-11-22 06:20:20 Re: Fwd: A million users