Re: logging queries

""Nick Fankhauser"" <nickf@ontko.com> wrote in message
news:NEBBLAAHGLEEPCGOBHDGOEHAFNAA.nickf@ontko.com...
> Hi-
>
> I'd like to set the logging or debug level so that the text of the queries
> that are executed show up in the log file. It seems to me that I recall
this
> being discussed before, but I can't find any specific references in the
> runtime-config portion of the docs.
>
> Can someone tell me if this is possible & if so, what runtime settings are
> needed?

Well,
in    postgresql.conf     put
debug_level = 2
debug_print_query = true


Ciao
Gaetano