On Mon, January 25, 2021 14:19, aNullValue (Drew Stemen) wrote:
>
> You're using double-quotes rather than single-quotes for string values.
>
> "SHM" = column
> 'SHM' = string value
>
On Mon, January 25, 2021 14:19, Peter Coppens wrote:
>
> Try single quotes
>
Thank you both.
--
***
> On 25 Jan 2021, at 20:17, James B. Byrne 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
> priv
At 2021-01-25T14:17:42-05:00, James B. Byrne 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 "S
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
