It's surely possible.
Just enable this at postgresql.conf:
log_destination = 'stderr'
redirect_stderr = on
And then choose what to log:
log_statement = 'all'
Valid values are none, ddl, mod, and all. ddl logs all data definition
commands like CREATE, ALTER, and DROP commands. mod logs all ddl
On Oct 9, 6:23 pm, [EMAIL PROTECTED] ("c k") wrote:
> Is it possible to log all sql statements submitted to database server in a
> table in that database it self? This will be different from database logs
> which are written by db server.
> Regards,
> CPK
I am not confident but it should be posibl
