Inserting multiple rows in a single PostgreSQL query

PostgreSQL

 

A well-known open-source database, developed by PostgreSQL Global Development Group. Skyvia requires the server to be available from Internet. Skyvia supports PostgreSQL, EnterpriseDB, Pervasive Postgres SQL servers, Heroku Postgres.

To insert multiple rows using the multirow VALUES syntax (for PostgreSQL 8.2 or newer)

Query Text

INSERT INTO public."Item" ("Id", name) 
VALUES  ('1', 'name1'),
        ('2', 'name2'),
        ('3','name3')
  

Open Query