Search Postgresql Archives

Re: Trigger Function question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Trigger Function question
From: Marcos Pegoraro <marcos@xxxxxxxxxx>
Date: Mon, 10 Jul 2023 15:51:14 -0300
Cc: Christophe Pettus <xof@xxxxxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <108381110.172129.1689014761308@connect.xfinity.com>
References: <1875078143.170839.1689013230630@connect.xfinity.com> <DF18ED9A-83D1-4CE8-888F-2BF3393CD9A3@thebuild.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>

Is there a way to get new.* into a jsonb column?

select json_object_agg(js.key, js.value) from json_each_text(row_to_json(new.*)) js

Marcos

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Trigger Function question
  - From: DAVID ROTH
- Re: Trigger Function question
  - From: Christophe Pettus
- Re: Trigger Function question
  - From: DAVID ROTH
- Re: Trigger Function question
  - From: Christophe Pettus
- Re: Trigger Function question
  - From: DAVID ROTH
- Re: Trigger Function question
  - From: Christophe Pettus
- Re: Trigger Function question
  - From: DAVID ROTH

Prev by Date: Re: Trigger Function question
Next by Date: Re: Trigger Function question
Previous by thread: Re: Trigger Function question
Next by thread: Re: Trigger Function question
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux