Column does not exist, pgAdmin 4

Question

INSERT INTO public."LeadCustomer"(
    "CustomerID", "FirstName", "Surname", "BillingAddress", "Email")
    VALUES ("12", "Lola", "Smith", "24 Cashmere Lane, Lancashire, LA4 6QT", "lolasmith@gmail.com");

ERROR:  column "12" does not exist
LINE 3:  VALUES ("12", "Lola", "Smith", "24 Cashmere Lane, Lancashir...
                 ^
********** Error **********

ERROR: column "12" does not exist
SQL state: 42703
Character: 111

use single quotes arround strings – Jens Apr 05 '17 at 13:08 — Jens, Apr 05 '17 at 13:08
Such a silly mistake! Thank you – Dani Miller Apr 05 '17 at 13:12 — Dani Miller, Apr 05 '17 at 13:12

score 18 · Answer 1 · answered Apr 05 '17 at 13:12

You're getting this error be PostgreSQL uses double quotes (") to signify system identifiers (such as tables, columns, etc.) while using single quotes (') to signify text.

You want your query to be:

INSERT INTO public."LeadCustomer"(
    "CustomerID", "FirstName", "Surname", "BillingAddress", "Email")
    VALUES ('12', 'Lola', 'Smith', '24 Cashmere Lane, Lancashire, LA4 6QT', 'lolasmith@gmail.com');

Column does not exist, pgAdmin 4

1 Answers1