Helpful Information

Category: PostgreSQL Help

Multiple inserts in one statement

Given a simple table (called simple_table)

id int
name varchar
state char

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)

Any takers?

Kyuzo

RTFM
http://www.postgresql.org/idocs/index.php?sql-insert.html

So, the answer is no, but you probably shouldn't do that anyway since its a non-standard extension that MySQL provides.