Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIw0V-0007qD-6p for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 18:53:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIw0U-0005Qo-0A for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 18:53:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIw0T-0005Qf-MI for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 18:53:09 +0000 Received: from smtp72.iad3b.emailsrvr.com ([146.20.161.72]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qIw0R-003Ka0-2g for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 18:53:08 +0000 X-Auth-ID: xof@thebuild.com Received: by smtp18.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 4E3FCE0147; Mon, 10 Jul 2023 14:53:05 -0400 (EDT) Subject: Re: Trigger Function question Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Content-Type: text/plain; charset=us-ascii From: Christophe Pettus X-Priority: 3 In-Reply-To: <108381110.172129.1689014761308@connect.xfinity.com> Date: Mon, 10 Jul 2023 11:52:04 -0700 Cc: "pgsql-general@lists.postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <13C4897F-7D63-40F2-A63F-BA0C0CDAAE39@thebuild.com> References: <1875078143.170839.1689013230630@connect.xfinity.com> <1715546791.171305.1689013799237@connect.xfinity.com> <870476B2-8403-46F4-BA0F-A03E226B07E3@thebuild.com> <242941212.171664.1689014226731@connect.xfinity.com> <8EE88849-3AF9-4B39-B547-B502173AE5F6@thebuild.com> <108381110.172129.1689014761308@connect.xfinity.com> To: DAVID ROTH X-Mailer: Apple Mail (2.3608.120.23.2.7) X-Classification-ID: 5fd32b57-738d-4ce1-b8ac-bfdc45a05b54-1-1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jul 10, 2023, at 11:46, DAVID ROTH wrote: >=20 > 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.=