Re: Trigger Function question
От | DAVID ROTH |
---|---|
Тема | Re: Trigger Function question |
Дата | |
Msg-id | 108381110.172129.1689014761308@connect.xfinity.com обсуждение исходный текст |
Ответ на | Re: Trigger Function question (Christophe Pettus <xof@thebuild.com>) |
Ответы |
Re: Trigger Function question
Re: Trigger Function question |
Список | pgsql-general |
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@thebuild.com> wrote: > > > > On Jul 10, 2023, at 11:37, DAVID ROTH <adaptron@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 queryto find out which columns the table that cause the trigger to fire has.
В списке pgsql-general по дате отправления: