Hi all,
Is there any way to do insert on conflict update all the null rows with
the excluded values.
For ex:
=>table1 will looks like =>table2 will
looks like
Column | Type | Modifiers Column | Type
| Modifiers
--------+---------+-----------
--------+---------+-----------
pk_t | integer | not null pk_t1 |
integer | not null
c1 | integer | col1
| integer |
c2 | integer | col2
| integer |
Indexes:
Indexes:
"t_pkey" PRIMARY KEY, btree (pk_t) "t1_pkey"
PRIMARY KEY, btree (pk_t1)
and for having left join result of table1 and table2 i have one view in the
form of table name newtable
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+-----------+---------+--------------+-------------
pk_t | integer | | plain | |
c1 | integer | | plain | |
pk_t1 | integer | | plain | |
col1 | integer | | plain | |
Indexes:
"mvjt_pk_t_idx" UNIQUE, btree (pk_t)
"mvjt_c1_idx" btree (c1)
and for upserting i am using
>>insert into mvjt select * from t left join t1 on t.pk_t = t1.pk_t1 and
pk_t1 in (select pk_t1 from log_t1) ON CONFLICT (pk_t) DO Update set
pk_t1 = EXCLUDED.pk_t1, col1 = EXCLUDED.col1;
The above query is with n attributes(here n will be 2 columns pk_t1 and col1).
Is there any simple method to update the conflict value to the table with
lesser query.?
cheers
- Harry
