Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Tell us what’s happening:
Describe your issue in detail here.
How to add name colum in this Table…
Your code so far

 Table "public.blackhole"
+--------------+---------+-----------+----------+-------------------------------------------------+
|    Column    |  Type   | Collation | Nullable |                     Default                     |
+--------------+---------+-----------+----------+-------------------------------------------------+
| blackhole_id | integer |           | not null | nextval('blackhole_blackhole_id_seq'::regclass) |
| gravity      | integer |           |          |                                                 |
| galaxy_id    | integer |           |          |                                                 |
| mhole        | boolean |           | not null | false                                           |
+--------------+---------+-----------+----------+-------------------------------------------------+
Indexes:
    "blackhole_pkey" PRIMARY KEY, btree (blackhole_id)

Your browser information:

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

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

To add a column to a table you use the following command:

ALTER TABLE table_name ADD COLUMN column_name DATATYPE CONSTRAINTS;

For example:

ALTER TABLE star ADD COLUMN name VARCHAR(30) NOT NULL;