Postgres Pro
Downloads
Home   >   mailing lists

FW: Single Line Query Logging - Mailing list pgsql-general

From Emre ÖZTÜRK
Subject FW: Single Line Query Logging
Date
Msg-id DUB122-W2456DEBEC1FD10A2A07DBDCE380@phx.gbl
Whole thread Raw
In response to Single Line Query Logging  (Emre ÖZTÜRK <emreozturk@outlook.com>)
Responses Re: FW: Single Line Query Logging  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: FW: Single Line Query Logging  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
List pgsql-general
Tree view
Hello all,

I have sent below question months ago but I could not get any reply from you experts. I will very appreciated if you can help.

PS: I have tried debug_pretty_print = off but I did not work.


Emre ÖZTÜRK


From: emreozturk@outlook.com
To: pgsql-general@postgresql.org
Subject: Single Line Query Logging
Date: Wed, 10 Jul 2013 13:16:13 +0300

Hello all,

Is there a parameter to log any SQL query as a single line in audit logs? I have some problems in my SIEM application. If a DBA sends the query as a single line I can gather the whole query, but if he enters like

UPDATE x  .......
          y=Z ......
          where ......

I only get the line starts with UPDATE then I can not see what is really changed in my SIEM logs. I have heard that there is a parameter do what I mean. Do you agree?

Regards,



Emre ÖZTÜRK

pgsql-general by date:

Previous
From: janek12@web.de
Date:
Subject: plpgsql code doen't work
Next
From: Beena Emerson
Date:
Subject: Re: plpgsql code doen't work