> From: bricklen [mailto:bricklen@xxxxxxxxx] > Sent: Thursday, July 16, 2009 4:05 PM > To: Relyea, Mike > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
