FW: 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: FW: Single Line Query Logging
Date: 2013-09-10 08:44:39
Message-ID: DUB122-W2456DEBEC1FD10A2A07DBDCE380@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)outlook(dot)com
To: pgsql-general(at)postgresql(dot)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


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Beena Emerson 2013-09-10 08:46:41 Re: plpgsql code doen't work
Previous Message janek12 2013-09-10 08:20:46 plpgsql code doen't work