Re: inserting multiple rows

From: reina_ga(at)hotmail(dot)com (Tony Reina)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: inserting multiple rows
Date: 2004-08-06 14:27:13
Message-ID: 272e4be7.0408060627.1a8449cc@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

schen(at)graciousstyle(dot)com (Si Chen) wrote in message news:<410E875B(dot)8050005(at)graciousstyle(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ron St-Pierre 2004-08-06 15:32:28 Re: lock entire database
Previous Message Tom Lane 2004-08-06 04:57:55 Re: take endless time to MAKE on RH Linux 9