-- it's a good practice to own all objects by one "application" role, so that changes could be done using the same role, -- not requiring the samewhat dangerous "superuser". SET ROLE TO demorole; -- ...

As you might recall from a previous episode, I'm trying to create a database for the circuit records at my office. I have imported all the equipment id's/locations/etc into 8 tables (one table for ...

We just learned about databases and SQL. Now let's put that knowledge into practice! In this lab, you will practice SQL by working with a PostgreSQL database. You will use the psql client to execute ...