Re: Inseting multiple rows at onece.

Steve <steve(at)zeropps(dot)uklinux(dot)net> wrote in message news:<3BD0B0F3(dot)39A9CBB3(at)zeropps(dot)uklinux(dot)net>...
> Hi
>
> I've got a table that has two columns in it one is a
> sequence and the second is
> a inet unique, and I want to add multiple rows all at once
> rather than issuing
> the insert comand two thousand times.
>
> Even when trying manually I can't get it to accept two rows
> at once, I've tried
> things like:
>
> INSERT INTO ip_list (ip_address) VALUES ('212.1.136.246',
> '212.1.156.23');
>
> and
>
> INSERT INTO ip_list (ip_address) VALUES ('212.1.136.246'),
> ('212.1.156.23');
>
> but just get parse errors. It's fine inserting one row at a
> time.
>
> Using perl using the Pg module is there a way of adding a
> whole array where each
> element will go into a seperate row.
>
> Any help greatly received.
>
> --
> Cheers
> Steve email mailto:steve(at)zeropps(dot)uklinux(dot)net
>
> %HAV-A-NICEDAY Error not enough coffee 0 pps.
>
> web http://www.zeropps.uklinux.net/
>
> or http://start.at/zero-pps
>
> 12:22pm up 124 days, 13:12, 2 users, load average: 1.00,
> 1.00, 1.00

Well, it is possible to add lots of rows in one operation with the SQL
command "COPY" (read Postgres' documentation) but running 2000 INSERT
queries on such type of table doesn't take a long time, since you seam
not to have lots of columns in your table ip_list.

Even if you have an index (unique or not) on one of the columns of
your table it won't be really time-consuming.

In my database I have a table with 350000 rows and inserting new rows
is very fast with the insert command (altougth it would be faster with
COPY - but COPY is usually used for data transfers with text files).

Regards,
xav.