postgresql 批量插入

postgresql 批量插入

直接插入多个数值

INSERT INTO films (code, title, did, date_prod, kind) VALUES
    ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
    ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');

通过另外一个表格的插入

INSERT INTO db.sheet1 select * from db.sheet2 

sheet1 和sheet2 的表格的需要一致。

通过关联表的插入

INSERT INTO 
	meta_data ( user_id, file_name, file_path, UPDATE_TIME ) 
VALUES
	( 'user_id01', 'file_name01', '/usr/local/file_name01', now()) 
ON CONFLICT
	(user_id, file_name) 
DO UPDATE SET 
	file_path =EXCLUDED.file_path, UPDATE_TIME = EXCLUDED.UPDATE_TIME;