Question 114887 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – While Inserting Data Showing Data as does not exist

Query

INSERT INTO public.employee
(id,first_name,last_name,salary,joining_date,department)
VALUES
(1, Monika, Arora, 100000, '2014-02-20 09:00:00', HR);

Output:

ERROR: column "monika" does not exist

Tags:

2

Answers


  1. 0

    Add single quotes, as this is how string constants are represented in SQL: 'Monika'

    Login or Signup to reply.
  2. 0

    Monika, Arora and HR should be quoted like that:

    INSERT INTO public.employee (id,first_name,last_name,salary,joining_date,department)
VALUES (1, 'Monika', 'Arora', 100000, '2014-02-20 09:00:00', 'HR');
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search