Run PostgreSQL
Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 1 of 20.
PostgreSQL stores data in named tables. A row describes one item; a column describes one attribute. The editor already contains a query that reads the product names.
Press Run and look for the name column in the result. The query asks PostgreSQL for data; it does not change the products. You do not need to edit anything in this first lesson.
Challenge
BeginnerPress Run to read the product names. The answer is already in the editor.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
SELECT name FROM products;All lessons in First Queries
Practice on your own: PostgreSQL playground