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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Michael Fuhr
> Sent: Wednesday, August 31, 2005 12:39 PM
> To: Frank
> Cc: Scott Marlowe; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 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@postgresql.org so that
your
> message can get through to the mailing list cleanly