i have an issue with the Intermediate Book Store Indexes project - https://www.codecademy.com/paths/design-databases-with-postgresql/tracks/how-do-i-make-sure-my-database-stays-fast/modules/indexes/projects/indexes-part-2-project - step 6.
I am not able to add the primary key for the customers table. It is not showing when i query the pg_indexes table and thus i’m not able to complete step 7.
my code is like this:
ALTER TABLE customers ADD CONSTRAINT customers_pkey PRIMARY KEY (customer_id);
and then i query
select * from pg_indexes;
but i do not see the index that should have been created by the primary key query.
Any idea why this is?