> On 10/4/07, test tester <test896@gmail.com> wrote:
> > i have version 8.1 and i want to know how to insert multiple rows in this
> version.
Please don't top post.
If you need this functionality, you should really upgrade.
In cases where you want to insert multiple rows in version 8.1, you
could use COPY command:
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
You use it like this:
COPY cars FROM STDIN DELIMITER AS ',' CSV;
5,toyota
6,ford
\.
Or if you really need to use INSERT you could use such construct:
INSERT INTO cars SELECT 5, 'toyota' UNION ALL SELECT 6, 'ford'
UNION ALL SELECT 7, 'bmw';
In short: really get the 8.2 version. 8.2 is compatible with earlier
versions and will be coming soon.
Regards,
Dawid
--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?
