newbie sql question...

From: Jason Ziegler <moo(at)zigfam(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: newbie sql question...
Date: 2003-05-27 05:07:48
Message-ID: 291852C8-9001-11D7-945B-0003930F1D7A@zigfam.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikola Milutinovic 2003-05-27 05:29:48 PostgreSQL 7.3.1 on WinXP
Previous Message Justin Clift 2003-05-27 04:35:58 [Fwd: PostgreSQL to index MEDLINE]