schen@graciousstyle.com (Si Chen) wrote in message news:<410E875B.8050005@graciousstyle.com>...
> Does PostgreSQL not support
>
> insert into mytable (row1, row2) values ('a', '1'), ('b', '2'), ('c',
> '3'), ('d', '4')
>
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