Does PostgreSQL not support

insert into mytable (row1, row2) values ('a', '1'), ('b', '2'), ('c',
'3'), ('d', '4')

? If not, does anyone know why not?

Si


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

According to the 7.4.3 documentation it's not possible
to insert more than one row with INSERT. See
http://www.postgresql.org/docs/curre...ql-insert.html

I think this is not a PGSQL issue, since SQL standard defines
INSERT command to insert one row at a time.

There are alternatives to insert multiple rows using a SELECT or a COPY.

http://www.postgresql.org/docs/curre.../sql-copy.html

http://pgsqld.active-venture.com/tutorial-populate.html

These links may help too:

http://archives.postgresql.org/pgsql...3/msg00076.php

http://archives.postgresql.org/pgsql...5/msg00047.php

http://www.faqs.org/docs/ppbook/r27281.htm

Regards,
Rafael Charnovscki

Si Chen wrote:

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

schen (AT) graciousstyle (DOT) com (Si Chen) wrote in message news:<410E875B.8050005 (AT) graciousstyle (DOT) com>...
No, but the COPY command can do something like this.

COPY INTO mytable FROM stdout;
a b c d
1 2 3 4



Take a look at http://www.postgresql.org/docs/7.4/static/sql-copy.html


-Tony