There has been some confusion about how to execute the code for the drills and the challenge. Several students have tried to execute all the code for the drills in the psql shell. And they are confused about the challenge where is says "Create a single SQL (.sql) file that creates tables and inserts some records into a blog database..."
My suggestion is to add section on running queries using a .sql file to the drills
psql -U dev -f ~/query.sql dev-restaurants-app
This would also lay the groundwork for the challenge
There has been some confusion about how to execute the code for the drills and the challenge. Several students have tried to execute all the code for the drills in the psql shell. And they are confused about the challenge where is says "Create a single SQL (.sql) file that creates tables and inserts some records into a blog database..."
My suggestion is to add section on running queries using a
.sqlfile to the drillspsql -U dev -f ~/query.sql dev-restaurants-appThis would also lay the groundwork for the challenge