Re: newbie sql question...

Dear Vincent, Stephan & Jean-Christian,

Thank you for your replies!
I ended up doing exactly what you all advised which of course worked
just fine.

Jason

On Tuesday, May 27, 2003, at 10:41 AM, Stephan Szabo wrote:

> On Tue, 27 May 2003, Jason Ziegler wrote:
>
>> Hello folks, I'm new to this list, and have been putting up with mysql
>> for too long, so please forgive me for asking such a newbie question
>> as
>> this:
>>
>> I have a query that works in mysql:
>> "INSERT INTO table1 ( id, column2, column3 ) VALUES ( '1', 'text
>> stuff', 'text stuff' ), ( '2', 'more text', 'even more text')"
>>
>> When I try this in postgresql, it won't work:
>> "INSERT INTO table1 ( 'id', 'column2', 'column3' ) VALUES ( '1', 'text
>> stuff', 'text stuff' ), ( '2', 'more text', 'even more text')"
>
> There are two problems with this. The first is that postgresql doesn't
> yet support multiple rows in the values section iirc, the second is
> that
> single quoting the column names will give a parse error.
>
> You can either use multiple inserts or possibly copy as workarounds.
>