Skip to main content.

JDBC Lab FAQ

How should I build SQL statements?
It's helpful to use the command-line interface into PostgreSQL, then build up the statements like we did with the examples in class. This is especially important with join queries.
  1. Select everything
  2. Then, filter using the where clause
  3. Then, filter on the column names.
But that's a lotta stuff to start!
Yes, that's true. Make your terminal window wider so that you see everything (or more stuff) more easily.
I got a lot of table rows--I don't want to scroll through them all. What do I do?
While the spacebar pages through the results, hitting q will exit out the paging.
What is another user name/password combination?
The test user's password is password