December 28th, 2001, 12:37 PM
Multiple inserts in one statement
Given a simple table (called simple_table)
in MySQL, you can use INSERT INTO simple_table(id, name) VALUES (1, 'Fred'), (2, 'John'), (3, 'Mary')......
...etc to add multiple entries with one statement.
Is there a comparable way to do this in Postgres? The above syntax doesn't seem to work (Postgres 7.1.2)
December 29th, 2001, 12:12 PM
December 29th, 2001, 08:23 PM
So, the answer is no, but you probably shouldn't do that anyway since its a non-standard extension that MySQL provides.