Postgresql批量更新、插入

批量更新、删除或插入数据

  • 1、批量插入 
    • INSERT INTO clouds_drew_task (id, cloudgeom)
VALUES
    (1, 'test11'),
    (2, 'test21'),
    (3, 'test31');

  • 2、批量插入有冲突就更新
    • 

    INSERT INTO clouds_drew_task (id, cloudgeom)
VALUES
    (1, 'test11'),
    (2, 'test21'),
    (3, 'test31') ON conflict (id) DO
UPDATE 
    SET cloudgeom = EXCLUDED.cloudgeom;;

  • 3、批量更新
    • 

    UPDATE clouds_drew_task 
SET cloudgeom = tmp.cloudgeom 
    (VALUES
        ( 13, 'new1' ),
        ( 14, 'new2' ),