PostgreSQL - Trigger Each Statement - How to get Query statement

Question

I'm doing a trigger Each Statement and I would like to access the Query Statement that triggered the trigger. Is this possible ?

Something like this:

update table_1 where id> 300;

This query triggers an update event in table table_1 and this event triggers a function associated with the update trigger. This trigger is configured as Each Statement and inside the trigger I would like to do something like this:

raise info 'Query Statement that fired this trigger:%', last_query();

Would this be possible?

Thank you!

Julio

I have not found a system function or view to do this in PostgreSQL. — pifor
– pifor, Commented Jun 10, 2020 at 16:05

Laurenz Albe · Accepted Answer · 2020-06-10 19:16:05Z

2

Call the function current_query().

answered Jun 10, 2020 at 19:16

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL - Trigger Each Statement - How to get Query statement

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