Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Tell us what’s happening:
Describe your issue in detail here.
I Have not added name Column for the galaxy thing So what do I Do?

Your code so far

universe=> INSERT into galaxy(name) VALUES('andromeda');
ERROR:  column "name" of relation "galaxy" does not exist

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

I would put the command \d galaxy and see what columns you have in your table. It appears as though you don’t have a column named name in that table.

3

How to add it??? This means the temporary my project is stuck and I Cannot move to the next phase Pls help!

4

You should be able to run an ALTER TABLE command on the galaxy table to add that column. If you can’t figure it out, please let us know and we’ll help more!

5

Pls share the Hint I cannot figure it out…

6

This is the command for adding a column to a table:

ALTER TABLE table_name ADD COLUMN column_name DATATYPE;