While Inserting Data Showing Data as does not exist

Question

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

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS — , Aug 31 '22 at 07:01
As @a_horse_with_no_name said, string values, like 'Monika','Arora', need to get 'single-quoted' — Stefan Wuebbe, Aug 31 '22 at 07:10

score 2 · Answer 1 · edited Aug 31 '22 at 07:12

2

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

edited Aug 31 '22 at 07:12

answered Aug 31 '22 at 06:44

WARUTS

72
7

score 0 · Accepted Answer · answered Aug 31 '22 at 07:14

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');

answered Aug 31 '22 at 07:14

VasiliyBukharov

68
1
7

While Inserting Data Showing Data as does not exist

2 Answers2