> On 25 Jan 2021, at 20:17, James B. Byrne <byrnejb@xxxxxxxxxxxxx> wrote: > > I am recreating a test database with data provided for a series of future > exercises. Presently I am trying to understand why a simple insert statement > is not working. The user invoking this insert is 'postgres' and has superuser > privileges. > > The error is this: > > 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 > 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”) > ; Try single quotes
