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