postgresql insert multi rows (bulk insert)

참고: https://www.postgresql.org/docs/current/sql-insert.html

INSERT

 

PostgreSQL 8.2 이후 버전에서 사용 가능

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