Why am i getting this error for my insert statement?

Asked Oct 14 '20 at 17:57

Active Oct 14 '20 at 18:06

Viewed 32 times

insert into filiaal (filiaalnummer, plaats, adres)
values (35, "Utrecht", "Stationsplein")

ERROR: column "Utrecht" does not exist LINE 2: values (35, utrecht, "Stationsplein")

Why does it say column Utrecht doesn't exist? I know it doesn't, i'm trying to enter "Utrecht" as a value in the plaats column of the filiaal table.

edited Oct 14 '20 at 18:03

asked Oct 14 '20 at 17:57

Jacob Zuma

It's because of the routes of quotes you use. – Maarten Veerman Oct 14 '20 at 18:00
It's because of the routes of quotes you use. – Maarten Veerman Oct 14 '20 at 18:00
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS – Oct 14 '20 at 18:09

0 Answers0