From: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: multiple insert into's (may be NEWBIE question) |
Date: | 2003-08-05 19:32:03 |
Message-ID: | AB815D267EC31A4693CC24D234F8291605687270@ACCLUST02EVS1.ugd.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks..
Travis
-----Original Message-----
From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
Sent: Tuesday, August 05, 2003 2:16 PM
To: Williams, Travis L
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question)
On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote:
> I have a table (lets say a,text b,text) and I want to insert the data
> jim,jimmy and trav,travis can I do this with 1 insert into statement
> instead of 2?
Not with the current implementation of insert. There's been some
discussion of adding the multiple tuple insert seen in other databases,
but I don't think anyone's actually done it or even agreed on exactly
how
to do it. I'm not sure if SQL 3 covers this, it seems like it hints at
it, but I can't read that stuff all that well most of the time.
I don't think there's a way right now though, without using some form of
copy.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-08-05 19:42:00 | Re: multiple insert into's (may be NEWBIE question) |
Previous Message | scott.marlowe | 2003-08-05 19:15:51 | Re: multiple insert into's (may be NEWBIE question) |