Home > mailing lists

Trigger to create string to inverse SQL statement - Mailing list pgsql-general

From	Łukasz Jarych
Subject	Trigger to create string to inverse SQL statement
Date	March 8, 2018 18:32:16
Msg-id	CAGv31of4T42BRO=KZMHNqaj1v2oo_bteeLdN2geKfTjxMtRu=w@mail.gmail.com Whole thread Raw
Responses	Re: Trigger to create string to inverse SQL statement
List	pgsql-general

Hello,

i have a trigger which is added log history:

It is possible to create additional column here with string with inversed SQL statement?

So in this case: "Delete FROM t_trig WHERE ID=1".

And what i want is to have possibility to loop through table and execute inversed sql statement for each row.

Please help,

Jacek Antek

From: Łukasz Jarych
Date: 08 March 2018, 18:26:55
Subject: Command to execute SQL string

From: Francisco Olarte
Date: 08 March 2018, 18:40:17
Subject: Re: Command to execute SQL string