Sorry guys, what I meant was to log the tuple returned count not the values to get printed in logs.
On Fri, Nov 22, 2024, 9:46 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish <jethish777@xxxxxxxxx> wrote:If an select query is fired I need the query returned values needs to be logged in my PostgreSQL log file.
Then the answer is no, and unlikely to become a feature anyone would develop or that we'd accept.A more innovative solution is going to need to be thought up to satisfy the security people that want to know what data was acquired from their system by either their users or semi-privileged hackers (privileged exploits would likely just disable such logging anyway). The space of setting up a proxy server in between clients and the PostgreSQL server is under-explored as a means by which to incorporate such functionality externally to the core server.David J.
