Re: Multiple insertion - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: Multiple insertion
Date
Msg-id 200603190214.k2J2Eht18254@candle.pha.pa.us
Whole thread Raw
In response to Multiple insertion  (Miguel <migabol@gmail.com>)
Responses Re: Multiple insertion  (shakil tanvir <tanvirshakil@yahoo.com>)
List pgsql-novice
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. +

pgsql-novice by date:

Previous
From: "Jonathan Davies"
Date:
Subject: Return count between timestamps
Next
From: shakil tanvir
Date:
Subject: Re: Multiple insertion