Maybe this example will help.
>From https://www.postgresql.org/docs/current/sql-insert.html
INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution')
ON CONFLICT (did) DO UPDATE
SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')'
WHERE d.zipcode <> '21201';
On Sat, Jan 23, 2021 at 3:47 PM Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 1/23/21 12:14 PM, Condor wrote:
> > On 23-01-2021 20:49, Adrian Klaver wrote:
> >> On 1/23/21 10:20 AM, Condor wrote:
>
> >
> > Sorry,
> >
> > I'm sorry, I don't understand something. You mean to do pure INSERT ON
> > CONFLICT DO or to modify the trigger ?
>
> No I meant that in the external program you use to fetch the data from
> the other table and reorganize the fields. Do your test there and do
> either the INSERT or UPDATE.
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
>
>
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!
