본문 바로가기

DB스토리/POSTGRESQL

postgresql merge query

with

upsert

as

(select 20 as user_id,'aaa' as hidden_columns, 50 as rows, 'bbb' as key, 'ccc' as default_columns),

update_option

as

(update config.users_info as u1 set hidden_columns = 'aaa',default_columns = 'ccc' 

from upsert where user_id = upsert.user_id and key = upsert.key)

insert into config.users_info 

select upsert.user_id, upsert.hidden_columns, upsert.rows, upsert.key, upsert.default_columns 

from upsert where not exists(select 1 from config.users_info where user_id = upsert.user_id and key = upsert.key );

'DB스토리 > POSTGRESQL' 카테고리의 다른 글