videoez.sql does not populate the customer table on AWS RDS

[kingparra]

I created a PostgreSQL instance on AWS RDS, connected to it, created the videoez db, set it as the default, and then ran videoezy.sql.

Afterwards, I ran select * from customer;. The output is empty.

Running INSERT INTO customer VALUES (1, 1, 'MARY', 'SMITH', '[email protected]', 5, true, '2006-02-14', '2006-02-15 09:57:20', 1); results in the error SQL Error [23503]: ERROR: insert or update on table "customer" violates foreign key constraint "customer_store_id_fkey" Detail: Key (store_id)=(1) is not present in table "store".

Do you have any idea what is going on?