Re: newbie sql question...

I'm a newbie too but I believe that you need to do:

INSERT INTO table1 ( id, column2, column3 )
values (1,'text stuff','text stuff');
INSERT INTO table1 ( id, column2, column3 )
values (2,'more text stuff','text stuff');

Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"

www.UrbanaSoft.com

----- Original Message -----
From: "Vincent Hikida" <vhikida@inreach.com>
To: "Jason Ziegler" <moo@zigfam.org>
Sent: Monday, May 26, 2003 10:48 PM
Subject: Re: [GENERAL] newbie sql question...


> I'm a newbie too but I believe that you need to do:
>
> INSERT INTO table1 ( id, column2, column3 )
> values (1,'text stuff','text stuff');
> INSERT INTO table1 ( id, column2, column3 )
> values (2,'more text stuff','text stuff');
>
> Vincent Hikida,
> Member of Technical Staff - Urbana Software, Inc.
> "A Personalized Learning Experience"
>
> www.UrbanaSoft.com
>
> ----- Original Message -----
> From: "Jason Ziegler" <moo@zigfam.org>
> To: <pgsql-general@postgresql.org>
> Sent: Monday, May 26, 2003 10:07 PM
> Subject: [GENERAL] newbie sql question...
>
>
> > 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 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>