At 2021-01-25T14:17:42-05:00, James B. Byrne <byrn...@harte-lyne.ca> sent: > postgres : STATEMENT: INSERT INTO public.stock( > stock_num, manu_code, description, unit_price, unit, unit_descr) > VALUES (3, "SHM", "aluminum Bat", 180.00, "case", "12/case"); > postgres : ERROR: 42703: column "SHM" does not exist at character 105 > postgres : LOCATION: errorMissingColumn, parse_relation.c:3194
You're using double-quotes rather than single-quotes for string values. "SHM" = column 'SHM' = string value
