When a SELECT query is issued in psql, it travels to the POSTGRESQL server, is executed, and the result then sent back to psql to be displayed. POSTGRESQL allows you to exert fine-grained control over which rows are returned. This chapter explores the methods available to achieve this goal.