Re: inserting multiple rows - Mailing list pgsql-novice

From reina_ga@hotmail.com (Tony Reina)
Subject Re: inserting multiple rows
Date
Msg-id 272e4be7.0408060627.1a8449cc@posting.google.com
Whole thread Raw
In response to inserting multiple rows  (Si Chen <schen@graciousstyle.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: lock entire database
Next
From: Steve Tucknott
Date:
Subject: Re: lock entire database