How to access statement text in Postgres trigger

Question

I'm attempting to put together what I thought would be a simple audit ability in Postgres. I intend to log session_id/user_id etc., but what I'm really after is logging the actual statement, in full. I know I can get the operation with TG_OP, but does anybody know the secret sauce to get the actual text of the current statement?

Bjarni Ragnarsson · Accepted Answer · 2021-01-22 07:33:59Z

4

This information can be retrieved with the current_query()function.

answered Jan 22, 2021 at 7:33

Bjarni Ragnarsson

1,7811 gold badge8 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to access statement text in Postgres trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related