Обсуждение: Multiple insertion

I need make multiple insertions in a new database under Postgresql 8.0 .
I will be satisfy if I can make this operation in a once operation. I
will be satisfied if I can make this operation in a once . I try use
INSERT TABLE ... VALUES (..), VALUES ( ); but in this way it doesn't
work. I am working in my degree project using java 5 and Postgresql 8.0.3 .
I hope if somebody may be explain if it is possible
Miguel Manzano

Miguel wrote:
> I need make multiple insertions in a new database under Postgresql 8.0 .
> I will be satisfy if I can make this operation in a once operation. I
> will be satisfied if I can make this operation in a once . I try use
> INSERT TABLE ... VALUES (..), VALUES ( ); but in this way it doesn't
> work. I am working in my degree project using java 5 and Postgresql 8.0.3 .
> I hope if somebody may be explain if it is possible

It is not possible but is on the TODO list.  You can put multipe inserts
in a single transaction if you want.

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +

Dear Bruce,

Following excerpt from a previous posting 
to this group should help you:

test=# create table tbl1 (x int, y int);
CREATE TABLE
test=# insert into tbl1 select 1,1 union select 2,2 union select 3,3;
INSERT 0 3
test=# select * from tbl1 ;
 x | y
---+---
 1 | 1
 2 | 2
 3 | 3
(3 rows)

Miguel wrote:
> I need make multiple insertions in a new database under Postgresql 8.0 .
> I will be satisfy if I can make this operation in a once operation. I
> will be satisfied if I can make this operation in a once . I try use
> INSERT TABLE ... VALUES (..), VALUES ( ); but in this way it doesn't
> work. I am working in my degree project using java 5 and Postgres ql 8.0.3 .
> I hope if somebody may be explain if it is possible

It is not possible but is on the TODO list. You can put multipe inserts
in a single transaction if you want.

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings