Re: Trigger Function question

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: DAVID ROTH <adaptron(at)comcast(dot)net>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Trigger Function question
Date: 2023-07-10 18:52:04
Message-ID: 13C4897F-7D63-40F2-A63F-BA0C0CDAAE39@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jul 10, 2023, at 11:46, DAVID ROTH <adaptron(at)comcast(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2023-07-10 18:54:08 Using "exit" to bring "goto" functionality.
Previous Message Marcos Pegoraro 2023-07-10 18:51:14 Re: Trigger Function question