Upserting all excluded values

["hari.prasath" <hari.prasath@xxxxxxxxxxxx>]

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