Re: Need another set of eyes on this - Mailing list pgsql-general

At 2021-01-25T14:17:42-05:00, James B. Byrne <byrnejb@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