Re: newbie sql question...

Wow, talk about delayed mail ... this was posted and answered a week ago
:) Guess this email had a stopover somewhere on the Internet or has been
wandering aimlessly on for a bit before deciding to make it's way to the
mailing list ...

Jean-Christian Imbeault

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')"
>
> I think I'm getting the syntax wrong for stringing together multiple
> value sets or something.
> Can anyone point me in the correct direction of how to do this properly,
> please?
>
> Thanks,
>
> jz
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--

Jean-Christian Imbeault