![](https://freecodecamp.org/news/content/images/size/w1000/2024/06/fotis-fotopoulos-DuHKoV44prg-unsplash.jpg)
Less than 1 minute
INSERT INTO :테이블명 (
:컬럼명1, :컬럼명2, :컬럼명3 /* ...[이하생략] */
) VALUES (
:컬럼1의값, :컬럼2의값, :컬럼3의값 /* ...[이하생략] */
) ON CONFLICT (:index컬럼명1, :index컬럼명2 /* ...[이하생략] */) DO UPDATE SET
:컬럼명1 = :컬럼1의값
, :컬럼명2 = :컬럼2의값
, :컬럼명3 = :컬럼3의값
/* ...[이하생략] */
;