Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger Function question - Mailing list pgsql-general

From Marcos Pegoraro
Subject Re: Trigger Function question
Date
Msg-id CAB-JLwY-6jo01RNjeWFOy4UC4LQ6OhH4mC8MvWsJaCW53amOGw@mail.gmail.com
Whole thread Raw
In response to Re: Trigger Function question  (DAVID ROTH <adaptron@comcast.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: DAVID ROTH
Date:
Subject: Re: Trigger Function question
Next
From: Christophe Pettus
Date:
Subject: Re: Trigger Function question