Re: multiple insert into's (may be NEWBIE question)

Thanks..

Travis

-----Original Message-----
From: scott.marlowe [mailto:scott.marlowe@ihs.com]
Sent: Tuesday, August 05, 2003 2:16 PM
To: Williams, Travis L
Cc: pgsql-general@postgresql.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.