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.johns...@gmail.com> wrote: > On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish <jethish...@gmail.com> > 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. >
