Tell us what’s happening:
Describe your issue in detail here.
I am getting “ERROR: column “milkyway” does not exist”
I dropped all my table and started from scratch but again got the same error. I tried removing these words and using different word, sentence , letter but getting same error every time.
Your code so far
universe=> ALTER TABLE galaxy ADD COLUMN name VARCHAR(30) NOT NULL;
ALTER TABLE
universe=> ALTER TABLE galaxy ADD COLUMN has_life BOOLEAN;
ALTER TABLE
universe=> ALTER TABLE galaxy ADD COLUMN description TEXT;
ALTER TABLE
universe=> ALTER TABLE galaxy ADD COLUMN age_in_million_of_years NUMERIC(10, 4);
ALTER TABLE
universe=> ALTER TABLE galaxy ADD COLUMN distance_from_earth_in_light_years INT;
ALTER TABLE
universe=> ALTER TABLE galaxy ADD COLUMN bigger_than_earth BOOLEAN;
ALTER TABLE
universe=> INSERT INTO galaxy (galaxy_id, id, name, has_life, description, age_in_million_of_years, distance_from_earth_in_light_years, bigger_than_earth)
universe-> VALUES (1, 1, milkyway, True, livable, 1245.411, 12445, True);
ERROR: column "milkyway" does not exist
LINE 2: VALUES (1, 1, milkyway, True, livable, 1245.411, 12445, True...
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0
Challenge: Build a Celestial Bodies Database
Link to the challenge: