testproduct_id | product_name | category_name ----------------+------------------------+---------------- 1 | Johns Fruit Cake | Confections 6 | Janes Favorite Cheese | Dairy Products 8 | Ellas Special Salmon | Seafood 9 | Roberts Rich Spaghetti | Grains/Cereals | | Condiments | | Meat/Poultry | | Beverages | | Produce (8 rows)