I saw your message about a "few" columns and missed the new.* notation. Is there a way to get new.* into a jsonb column? > On 07/10/2023 2:38 PM EDT Christophe Pettus <xof@xxxxxxxxxxxx> wrote: > > > > On Jul 10, 2023, at 11:37, DAVID ROTH <adaptron@xxxxxxxxxxx> wrote: > > > > Thanks for the example. I have a test trigger now that does that but my application needs all of the columns. > > I'm not quite sure I understanding. Logging NEW.* and OLD.* *does* get all the columns, without having to specific query to find out which columns the table that cause the trigger to fire has.
