Search Postgresql Archives

Re: PostgreSQL Log Info

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/21/24 23:32, 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

What if the query returns 500,000 rows?


What is the purpose of retaining this information?



On Fri, Nov 22, 2024, 10:49 AM David G. Johnston <david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>> wrote:

    On Thursday, November 21, 2024, Jethish Jethish
    <jethish777@xxxxxxxxx <mailto:jethish777@xxxxxxxxx>> 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.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux