In Chapter 7, Getting Started with the Database, we were introduced to YeSQL for interacting with our database. We used YeSQL to create an
INSERT statement which added our new users to the database. Similarly, we can use YeSQL to
SELECT records from the database. If you can do it in SQL, you can do it with YeSQL. And that's the beauty of YeSQL: it's just SQL. This allows us to open an SQL tool of our choice and experiment with our query until we get it right.
For this next bit, we'll use the
psql tool to verify our SQL. But you're free to use whatever SQL editor you have at your disposal. Take the following steps:
psqland connect to our database:
# psql -U hipstr -d postgres -h localhost ...