> From: bricklen [mailto:bricklen@gmail.com]
> Sent: Thursday, July 16, 2009 4:05 PM
> To: Relyea, Mike
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Error in insert statement
>
> Try dropping the word "VALUES".
>
> eg.
> INSERT INTO "tblSpecs" ("CartridgeTypeID", "ColorID",
> "TestTypeID","ZoneID", "PaperID", "AttributeID", "Spec")
> SELECT "CartridgeTypeID", "ColorID", "TestTypeID","ZoneID",
> "PaperID", "AttributeID","Spec" from "tblTempSpecs";
>
I knew there had to be some bone-headed mistake I was making. That
worked of course. Thanks.