Re: Need another set of eyes on this

> On 25 Jan 2021, at 20:17, James B. Byrne <byrnejb@harte-lyne.ca> 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