If the inserts are all a bunch of data statements like that, a SED script could turn them into something for bulk load via COPY easily enough. Might be an even better solution, depending on what the OP is trying to accomplish. > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Michael Fuhr > Sent: Wednesday, August 31, 2005 12:39 PM > To: Frank > Cc: Scott Marlowe; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: newbie - postgresql or mysql > > On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote: > > This fails to insert records > > > > >> insert into category values > > >> (4, 'Hardware - Monitor', 2, '2004-10-12 10:50:01'), > > >> (5, 'Hardware - Printer', 2, '2004-10-12 10:50:02'), > > >> (6, 'Hardware - Terminal', 2, '2004-10-12 10:50:02'), > > PostgreSQL doesn't support this form of INSERT; you'll have to use > a separate INSERT per record or use COPY. Another method, although > probably not useful in this case, is to insert records from a subquery; > see the INSERT documentation for more information. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
