| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> |
| Cc: | "pgsql-in-general(at)postgresql(dot)org" <pgsql-in-general(at)postgresql(dot)org> |
| Subject: | Re: Single Line Query Logging |
| Date: | 2013-07-10 09:54:55 |
| Message-ID: | CABOikdNCqUc-w2jaS+kYvT_jyL=1zJN1qZeVK6UdBDevjmJ6Vg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-in-general |
On Wed, Jul 10, 2013 at 3:17 PM, Emre ÖZTÜRK <emreozturk(at)outlook(dot)com> wrote:
> 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?
>
>
Try debug_pretty_print = off (though I haven't used that myself). BTW, this
is a India specific list and the chances of you getting a better and timely
answer are better if you post on pgsql-general.
Thanks,
Pavan
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emre ÖZTÜRK | 2013-07-10 10:14:22 | Re: Single Line Query Logging |
| Previous Message | Emre ÖZTÜRK | 2013-07-10 09:47:52 | Single Line Query Logging |