Single Line Query Logging

From: Emre ÖZTÜRK <emreozturk(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Single Line Query Logging
Date: 2013-07-10 10:16:13
Message-ID: DUB122-W5E9C8DD9AF2F0B005F296CE7A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2013-07-10 10:16:33 Re: Force ssl connection
Previous Message Muhammad Bashir Al-Noimi 2013-07-10 10:04:56 Re: Force ssl connection