Andrew Bartley wrote:
> Can someone please tell me how to log the values being inserted in this example..
>
> 2018-06-12 22:31:49 UTC-5b2049d4.434ac-STATEMENT: insert into "api_consumers" ("consumer_id", "create_datetime")
values($1, $2).
>
> I have tried many different logging options and combinations.
That should automatically be logged as a DETAIL message.
log_min_duration_statement = 0
log_min_error_statement = log or better
log_min_messages = log or better
That should do the trick.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com