How to reduce multiple insert into in postgresql?

Question

is it possible to reduce a multiple insert into in PostgreSQL.

i have this:

insert into table (id,name,city)
values ('1','Mike','Orleans')

insert into table (id,name,city)
values ('2','Paul','Paris')

so i have to insert more than 100 datas. Can we do it in one query

Thank you

user330315 · Accepted Answer · 2016-01-28 15:00:47Z

1

insert into the_table (id,name,city)
values 
  (1,'Mike','Orleans'),
  (2,'Paul','Paris');

If id is an integer column, then don't provide a string value for it. '1' is a string (character) value. Numbers are specified without single quotes: 1 is a number.

answered Jan 28, 2016 at 15:00

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to reduce multiple insert into in postgresql?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related