Import bookshop database with pqAdmin

Create the bookshop Database

Download dump-bookshop.sql from Blackboard and choose to restore the bookshop daabase

Ignore the errors, under schemas -> public -> tables, you will see 8 tables created

Run SQL statements

You can run SQL statements on those tables, for example you can run

SELECT * FROM authors;