INSERT INTO public."LeadCustomer"(
"CustomerID", "FirstName", "Surname", "BillingAddress", "Email")
VALUES ("12", "Lola", "Smith", "24 Cashmere Lane, Lancashire, LA4 6QT", "[email protected]");
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
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', '[email protected]');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With