From: | Rafael Charnovscki <charnovs(at)unesc(dot)rct-sc(dot)br> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | schen(at)graciousstyle(dot)com |
Subject: | Re: inserting multiple rows |
Date: | 2004-08-03 14:18:27 |
Message-ID: | 410F9EB3.2050004@unesc.rct-sc.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/current/interactive/sql-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/current/interactive/sql-copy.html
http://pgsqld.active-venture.com/tutorial-populate.html
These links may help too:
http://archives.postgresql.org/pgsql-sql/2003-03/msg00076.php
http://archives.postgresql.org/pgsql-novice/2002-05/msg00047.php
http://www.faqs.org/docs/ppbook/r27281.htm
Regards,
Rafael Charnovscki
Si Chen wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2004-08-03 14:22:44 | Re: help with COPY from .csv file into database |
Previous Message | mike | 2004-08-03 12:15:02 | help with COPY from .csv file into database |