-1

Insert into Customer( Customerid, Username, Fname, Lname, Street1, Street2, City, State, Zip

) VALUES(42, “Guitarhero”, “Wes”, “Montgomery”, “Mainstreet”, “Manhattan”, “NY”, 12304); ERROR: column "“guitarhero”" does not exist

camille
  • 16,432
  • 18
  • 38
  • 60
brandker
  • 1
  • 3

1 Answers1

0

You're using double quotes for strings instead of single quotes. Double quotes indicate a column name, and single quotes indicate a string. Try this:

Insert into Customer (Customerid, Username, Fname, Lname, Street1, Street2, City, State, Zip)
VALUES (42, 'Guitarhero', 'Wes', 'Montgomery', 'Mainstreet', 'Manhattan', 'NY', 12304);

Also note that you're using uppercase letters in your table and column names, but those will be changed to lowercase by postgres unless you put them in double quotes.

Blue Star
  • 1,932
  • 1
  • 10
  • 11
  • I trried that and it still did not work insert into customer( customerid, username, fname, lname, street1, street2, city, state, zip) VALUES(42, ‘guitarhero’, ‘wes’, ‘montgomery’, ‘mainstreet’, ‘manhattan’, ‘ny’, 12304); – brandker Sep 14 '20 at 03:43
  • @brandker What error are you getting now? – Blue Star Sep 14 '20 at 05:27
  • Im getting column "‘guitarhero’" does not exist This is my code : insert into customer( customerid, username, fname, lname, street1, street2, city, state, zip) Values(42, ‘guitarhero’, ‘wes’, ‘montgomery’,’mainstreet’,’broadway’, ‘manhattan’, ‘ny’, 12304); – brandker Sep 14 '20 at 21:31