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 <x...@thebuild.com> wrote: > > > > On Jul 10, 2023, at 11:37, DAVID ROTH <adapt...@comcast.net> 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.
