Single Line Query Logging

From: Emre ÖZTÜRK <emreozturk(at)outlook(dot)com>
To: "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org>
Subject: Single Line Query Logging
Date: 2013-07-10 09:47:52
Message-ID: DUB122-W394891055803E2BF925BECCE7A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-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-in-general by date

  From Date Subject
Next Message Pavan Deolasee 2013-07-10 09:54:55 Re: Single Line Query Logging
Previous Message amora amora 2013-06-16 10:49:24 from researcher in database buffer cache