Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger Function question - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Trigger Function question
Date
Msg-id 13C4897F-7D63-40F2-A63F-BA0C0CDAAE39@thebuild.com
Whole thread Raw
In response to Re: Trigger Function question  (DAVID ROTH <adaptron@comcast.net>)
Responses Re: Trigger Function question
List pgsql-general
Tree view 

> On Jul 10, 2023, at 11:46, DAVID ROTH <adaptron@comcast.net> wrote:
>
> Is there a way to get new.* into a jsonb column?

The to_jsonb() function accepts a row type like NEW.*, and returns a JSONB object with the keys as column names.

pgsql-general by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Trigger Function question
Next
From: Bryn Llewellyn
Date:
Subject: Using "exit" to bring "goto" functionality.