From: | shakil tanvir <tanvirshakil(at)yahoo(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Multiple insertion |
Date: | 2006-03-19 04:23:53 |
Message-ID: | 20060319042353.62588.qmail@web52415.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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)
Regards,
Shakil
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote: 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. +
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------------
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2006-03-19 09:41:52 | Re: Return count between timestamps |
Previous Message | Bruce Momjian | 2006-03-19 02:14:43 | Re: Multiple insertion |