Search Postgresql Archives

Re: Need another set of eyes on this

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux