On Fri, Nov 22, 2024 at 9:26 AM Jethish Jethish
wrote:
> Sorry guys, what I meant was to log the tuple returned count not the
> values to get printed in logs.
>
That too is a no. Though more because is just doesn't seem useful enough
to expend effort on designing and implementing something.
The
On 11/21/24 21:02, Jethish Jethish wrote:
Hi Everyone,
Is it possible to log the rows returned by a query in the PostgreSQL logs?
https://github.com/pgaudit/pgaudit/blob/main/README.md
"pgaudit.log_rows
Specifies that audit logging should include the number of rows retrieved
or affected by
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
wrote:
> On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish
> wrote:
>
>> If an select query is fired I need the query returned values needs to be
>>
On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish
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
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
Am Fri, Nov 22, 2024 at 01:02:27PM +0530 schrieb Jethish Jethish:
> If an select query is fired I need the query returned values needs to be
> logged in my PostgreSQL log file.
What do you expect your log file to be in size after, say, a
day of activity ?
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6
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
Isn't "I need the query returned values" the purpose of the client
application?
On Fri, Nov 22, 2024 at 2:32 AM 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
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
wrote:
> On Thursday, November 21, 2024, Jethish J
On Thursday, November 21, 2024, Jethish Jethish
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 though
10 matches
Mail list logo
