Date: Fri, 22 Nov 2024 12:25:44 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Jethish Jethish <jethish777@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
	pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL Log Info
Message-ID: <Z0BqOL2dGd9oCqiy@depesz.com>
Reply-To: depesz@depesz.com
References: <CAKeSjMiBZuMX+R3mTmxj-5DUqKN9disMALRnTPv-5B3+CUn6Hg@mail.gmail.com>
 <CAKFQuwYNhgArOxhAXwbf3cY=jmJnKYo8c1R66NLFtAvpmKktCA@mail.gmail.com>
 <CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/Z0BqOL2dGd9oCqiy%40depesz.com>
Precedence: bulk

On Fri, Nov 22, 2024 at 01:02:27PM +0530, 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

Please note that you wrote what you want to do. And David asked about
use case. Which is different.

Basically the question can be summed into: *why* you think you want
that.

I don't think anything even remotely similar to this exists. You could,
of course, add it to Pg by changing sources (it is open source after
all), but given that such feature would be downright dangerous for huge
majority of situations, I don't expect it to become reality in mainline
Pg.

Best regards,

depesz